Crystal Reports DateTime Formatting

Question

I would like to format the date and time in Crystal Reports to include the day of the week.

From:

06/06/2009

To:

Friday June 19, 2009

Answer 1

In Crystal Reports XI Release 2, you can right-click on a field and go to the "Format" field. On the Date and Time tab, click the Settings button. On the Date tab, change the date type down to Windows by default.

Answer 2

If in the formula you can use the following.

CSTR({ ?@end _dt}, "dddd, MMMM d, yyyy") 

Answer 3

If DateTime is in a field (not a formula):

 Right click on the field -> Format Editor Date and Time tab Select date/time formatting you desire (or click customize) 

---

If datetime is in the formula:

 ToText({MyDate}, "dd-MMM-yyyy") 

Answer 4

You can use this formula:

 CSTR(Date({command.EntryDate}), "dd/MM/yyyy")