Date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to change the format of a calculated date in a report. It looks
like this:

="Respond to this notice by " & [BLDate]+14 &"."

The field [BLDate] is formatted as mmmm dd", "yyyy in the table. I want the
calculated date above to have this format as well. The problem is it shows
up as "Respond to this notice by 2/1/06."

How do I format this calculated date to show as mmmm dd", "yyyy?

Any help will be appreciated.

Thanks!
 
Change the expression to:

="Respond to this notice by " & Format([BLDate]+14, "mmmm dd, yyyy.")

Ken Sheridan
Stafford, England
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing report with date 3
Text to date format? 0
Date format in a report 2
Date format when exporting 2
Dates 4
Dlookup 7
Date Formatting 1
access, date field 1

Back
Top