Date format in crystal report

Rowley150 · January 10, 2019, 9:55pm

crystal report date format change…

hi guys, i’ve been asked to change a date format which appears dd-mm-yyyy to “10-Jan-2019” format.

On the 2nd screenshot, i need Box B to be the same format as box A.
when i right click to edit formula it shows this pop up box…i think the field is a calculated text string, so how can i adjust it to the new format?

Many thanks in advance.

vantage03 · January 10, 2019, 10:15pm

Try ToText(CDate({TableName.FieldName}), “dd-MMM-yyyy”)

vantage03 · January 10, 2019, 10:18pm

ToText(CDate({TableName.FieldName}), “dd-MMM-yyyy”)

Rowley150 · January 10, 2019, 11:17pm

There is no table/field name…it’s just a label string that I think returns the current date

vantage03 · January 11, 2019, 1:25pm

Try

ToText(CDate(CurrentDate), “dd-MMM-yyyy”)

Rowley150 · January 12, 2019, 1:42pm

this did the trick…

if {POHeader.PrintAs} = ‘C’ then ToText ((CurrentDate),“dd-MMM-yyyy”) else ‘’

thank you for your help