Day

[Chris]

How Do I display the date as; Friday 02/04/2006

Basically I only need a way of finding out what todays' Day (Mon, Tues, etc)
is and I can append it onto the ddmmyy date.

 

[Duane Hookom]

If you have a date/time field, you don't need to store the day of the week
since it can always be displayed. If you are storing the date in a text
field, you need to convert it to a date/time value and then use the Format()
or other function.

Format([datefield],"dddd mm/dd/yyyy")

It isn't clear whether you wanted mm/dd or dd/mm since there is no Friday,
April 2 or Friday, February 4.