DATE FUNCTIONS

[Guest]

IF DATE() RENDERS THE NUMERIC DATE, HOW DO I USE A FUNCTION TO CONVERT IT TO
THE DAY OF THE WEEK (MON, TUES ...)

 

[John Vinson]

IF DATE() RENDERS THE NUMERIC DATE, HOW DO I USE A FUNCTION TO CONVERT IT TO
THE DAY OF THE WEEK (MON, TUES ...)

Please lay off the CAPS LOCK key. It looks like you're SHOUTING and
it's hard to read.

The Format property of a textbox can be set to

ddd

for Mon, Tue, Wed, or to

dddd

for Monday, Tuesday, Wednesday.

The date is actually stored as a number, but you can display it any
way you like. Just set the Format property of the field, or the form
or report textbox; or use the Format() function to explicitly cast the
date into a string.

John W. Vinson[MVP]