date format in CR

sruthi ramachandrula

Hi

can any one tell how to set date format as "20th sep 2010" in CR XIR2. Similarly for the whole month

Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Felipe Ramos16y ago
This link contains a table with all the formats you can set:
http://publib.boulder.ibm.com/infocenter/radhelp/v7r5/index.jsp?topic=/com.businessobjects.integration.eclipse.designer.doc/html/topic629.html

http://publib.boulder.ibm.com/infocenter/radhelp/v7r5/index.jsp?topic=/com.businessobjects.integration.eclipse.designer.doc/html/topic629.html
sruthi ramachandrula16y ago
hi

I tried it is giving me output "23r23 sep 2010". please suggest
Felipe Ramos16y ago
Mahesh wrote a good article on using the formatter http://www.c-sharpcorner.com/UploadFile/mahesh/DateFormatInCR06132007092248AM/DateFormatInCR.aspx, but if you need to keep the formulate try this

ToText({?P_VALUE_DATE_D}, "dd-MMM-yyyy")
sruthi ramachandrula16y ago
Hi,
i am using the below formula. problem here is Cr is taking in "rd", d as day of month without leading zero for single digits
IF CStr (CDate ({?P_VALUE_DATE_D}),"dd" )="23" THEN
CStr (CDate ({?P_VALUE_DATE_D}),"ddrd MMM yyyy")
please suggest.

Thanks
sruthi
Felipe Ramos16y ago
If you are returning a datetime for the field from a storedProc or your source Crystal will know and allow you the options by right clicking on the field and picking the date format that matches your description. If you can't find a format there you can build your own using a formula.
Gomathi Palaniswamy16y ago
Hi friend,

You can change by format editor. right click your printdate object and select the format of date.

With Regards,
Gomathi.P