Converting Date Field to Day of the Week

[titans4771]

I have the below field:

command.date, this is how it shows on the report now:

2009-7-22, how can I get it to show 'Monday' as opposed to the date itself?

Thanks!

 

[CoSpringsGuy]

//dayofweekname
select dayofweek({@date})
case 1:"Sunday"
case 2:"Monday"
case 3:"Tuesday"
Case 4:"Wednesday"
case 5:"Thursday"
Case 6:"Friday"
Case 7:"Saturday"

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

You could just use:

weekdayname(dayofweek({command.date}))

-LB

 

[CoSpringsGuy]

OK I spose that one is a little better





_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection