Changing a date to the day of the week 3

[jlp118]

I have a report that gives me everything I need. The date field I have, shows the date ie. 07/26/2001. How do I convert the date to instead of showing "07/26/2001" to show "Thursday"? Thank you in advance for your help.

Jeff

 

[jjames]

StringVar Array DaysOfWeek := ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"];

DaysOfWeek[DayofWeek(DateField)]

 

[Andie]

You can also create a variable "Day of week" and use the formula:

ToText({date},"dddd&quot

where {date} is your current date field. This will return the correct day in the form "Thursday".