Date to weekday

tj007 · Apr 26, 2004

Hi

Can I derive a day of the week (e.g. Monday) from a long or short date (e.g. 1/29/2004) in Crystal Reports 8.0?

bdreed35 · Apr 26, 2004

This will get you the weekday name:

@Weekday_Name

Code:

WeekdayName (DayOfWeek ({table.date}))

~Brian

tj007 · Apr 26, 2004

Thanks perfect.

Madawc · Apr 27, 2004

In Crystal 8.5, you could also have

Code:

Totext({your.date}, "dddd")

Also ddd for Mon, Tue etc. And lots of other useful options, but I don't know if Crystal 8 allows this.

Madawc Williams
East Anglia, Great Britain