extract week day

[Guest]

Hi,

I have a time field "Gdate" formatted like: 11/12/2007 6:57:58 AM
Is there a way to extract the week day (like "Thu") from this field ?

Thanx

 

[Guest]

Format(Gdate, "ddd")

 

[Douglas J. Steele]

Format(Gdate, "ddd") will return "Thu", Format(GDate, "dddd") will return
"Thursday".

 

[John W. Vinson]

Hi,

I have a time field "Gdate" formatted like: 11/12/2007 6:57:58 AM
Is there a way to extract the week day (like "Thu") from this field ?

Thanx

It's not really a matter of extracting anything. A Date/Time value is actually
stored in the table as a double float number, a count of days and fractions of
a day since midnight, December 30, 1899.

You can apply any desired format to this field - for instance, if you display
this field on a form or report in a textbox with a format property of

"ddd"

you'll see "Mon". You can use a format of

"ddd, mmm dd yyyy, hh/nn"

to see

Mon, Nov 12 2007, 6:57

See the online help for Format and dig down to custom date formats for more
options.

John W. Vinson [MVP]