date conversion

[catchingup]

I am using cr11 and need to get the day of the week to convert to the actual word for the day of the week.
Currently the way the report is built it pulls the work week and lists the number of he day in the month (1-30, etc)
I used a CDate formula to get that to translate in 5/1/2006, 5/2/2006, etc. But what I ultimately want is for it to indicate Monday, Tuesday, Wednesday, Thursday, and Friday.

Any hints/suggestions?

 

[synapsevampire]

Once you have a valid date field (using your cdate function), use the following:

weekdayname(weekday(<your date field>))

-k

 

[catchingup]

Thank you! That worked!! I knew there was a way and i was swirling around it. Much appreciated!