Am New to Crystal Report 8.5
How to print the string value in a date Format?
Example:
dd/mm/yyyy
Where i have to type a formula in the crystal report?
Need Date Separator Formula for String value? How to create a fromula in crystal report 8.5?
+2
A:
Create a new formula field to use in the report and use the CSTR or TOTEXT functions for formatting of the date.
You can use the help in the formula editor to look up the CSTR and TOTEXT functions to get the exact format that you want.
Here is a link for something similar. Look at the 2nd answer. http://stackoverflow.com/questions/980877/crystal-reports-datetime-formatting/981730#981730
Dusty
2009-06-29 13:31:37
thank you for this helped SOOO much!
Jreeter
2009-07-30 21:56:46
+1
A:
To answer your second question...
To create a formula field in CR 8.5:
Insert Fields->Formula tab->New
in CR 10 and up:
go to the "Field Explorer", right click "Formula Fields", click "New".
or
Report->Formula Workshop->Formula Fields->New
Then you can drag the formula field onto the report.
dotjoe
2009-06-29 15:43:07
+1 for explaining the part I didn't feel like explaining. :)In Crystal 8.5 I think you add them from the Insert menu, but it's been a while so I could be wrong.
Dusty
2009-06-29 15:50:45
I noticed the OP had posted the same question twice. Yea, I don't remember much about 8.5 either. It is different though, will update answer.
dotjoe
2009-06-29 15:58:02