CODEWITHSUNDEEP
datetimecrystal-reportsformatting
Nathan Koop
Nathan Koop

Reputation: 25197

Crystal Reports DateTime Formatting

I'd like to format a datetime in Crystal Reports to a include the day of week.

From:

19/06/2009

To:

Friday, June 19, 2009

Upvotes: 4

Views: 58707

Answers (4)

Kurniawan Prasetyo
Kurniawan Prasetyo

Reputation: 729

If the DateTime is in 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 the datetime is in a formula:

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

Upvotes: 2

Dusty
Dusty

Reputation: 4697

If in a formula, you can use the following.

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

Upvotes: 8

kittu
kittu

Reputation: 1

You can use this formula:

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

Upvotes: 0

Dusty
Dusty

Reputation: 4697

In Crystal Reports XI Release 2 you can right click on the field and go to Format Field. On the "Date and Time" tab click the customize button. Under the Date Tab change the Date Type drop down to "Windows Default Long".

Upvotes: 4

Related Questions