Convert Weekday from # to Descriptive "Mon"

  • Thread starter Thread starter Ralph Wischnewski
  • Start date Start date
R

Ralph Wischnewski

I have a feild in a report that shows the day of the week
as a date feild using the "Weekday" function. I would
like the report to show "Mon" rather than "2". How do I
achieve this?

Thank you
 
Ralph said:
I have a feild in a report that shows the day of the week
as a date feild using the "Weekday" function. I would
like the report to show "Mon" rather than "2". How do I
achieve this?
Click to expand...

Use the Format function instead or the WeekDay function.

Format(datefield, "ddd")
 
Back
Top