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]
