Date format question

andrefrancis

andrefrancis
Local time
Today, 13:12
Joined
Mar 11, 2005
Messages
40
I have a form field which displays the date in medium date format - thus 6/2/2005 (UK style) for the 6th Jan 2005.

I need to format it with an added short day of week at the beginning - thus Wed 6/2/2005. :confused:

Can anyone help?

Thanks.
 
Try:

Format$([DateField] , "ddd dd/mm/yyyy")
 
RichO said:
Try:

Format$([DateField] , "ddd dd/mm/yyyy")

Thanks RichO ... it worked perfectly :D ... as a function for a calculated variable in relevant queries.

I was trying to use the 'ddd' form in the format property (duh!)
 

Users who are viewing this thread

Back
Top Bottom