Nice and Easy Weekday Question

[Fiona]

Hi there,

I'm trying to get my form to generate the weekday from the date entered. I can only get it to display the weekday as a number eg. 1 for Sunday. How can I get it to say "Sunday" instead?
Thanks in advance,

Fiona

 

[Jack Cowley]

A demo is on its way to you.

 

[brucesilvers]

Could you give us a hint as to what that demo involves? Is there an easy way to do it without complicated code or creating a table to hold the weekday text values?

 

[simongallop]

In Query. Field Header field name DATE

If you want DATE converted to day of the week (Numeric where 1= Sunday etc.)
Format([DATE],"w")

If you want DATE converted to day of the week (Word eg Sunday etc.)
Format([DATE],"dddd")

HTH