weekday function help

  • Thread starter Thread starter Clyde Lomax
  • Start date Start date
C

Clyde Lomax

Good evening,
I have a query that I am creating a new field as below; date 1.

date1: Weekday([date_orig])

The function that I have is returning 1 2 3 etc for the number of the day
that is in existing field "date_orig". What must I do for the day to appear
Sunday, Monday etc.?

thanks in advance,

an avid lurker..

lomax
 
Format([date_orig], "ddd") will give you Sun, Mon, Tue, while
Format([date_orig], "dddd") will give you Sunday, Monday, Tuesday...
 
Back
Top