Format Date on Form 1

[wonderwhy]

I want to display a date from a subform on my form and format it like: Thursday, May 12, 2005

I currently have it displaying on a text box (like a caption for a subform) using:

=[qryFrmSubSleepEpisode]!EpisodeDate

but I can't seem to get the syntax right to format it like I want to (above).

Help would be appreciated,

Julia

 

[PHV]

Have you tried this ?
=Format([qryFrmSubSleepEpisode]!EpisodeDate, "dddd, mmmm dd, yyyy")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wonderwhy]

No, but it works perfectly! I was trying to put the 'Format' before the field name in the expression. I didn't know to put it at the beginning.

Thank you very much!

Julia

 

[mguidry5]

Try this:

=FormatDateTime([qryFrmSubSleepEpisode]![EpisodeDate],1)