Date format question

[andrefrancis]

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.

Can anyone help?

Thanks.

 

[RichO]

Try:

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

 

[andrefrancis]

Try:

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

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

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