Results 1 to 1 of 1
2002-02-16, 15:40 #1
- Join Date
- Nov 2001
- Arlington, Virginia, USA
- Thanked 3 Times in 3 Posts
Re: Date format in a text box (97SR2)
Edited by Charlotte:
Since the original post was deleted, here is the question that was asked:<hr>Please help this newbie with what seems like an easy question.
How do I format a date that is part of a text field on a report? For example:
="My dog ate my cat in the month of " & [eat_date] & "."
I want it to say: My dog ate my cat in the month of November, 2001.
How do I format [eat_date] within this text box? Thanks for your help<hr>
In the text box Control Source property enter expression similar to:
<pre>="The dog ate my homework in the month of " & Format([DATE_FLD],"mmmm"", ""yyyy") & "."</pre>
For other custom date formats check help file topic titled "Format Property