weekday function help

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
 
D

Douglas J. Steele

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