Extracting part of a date in a report

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

Guest

I have a table that we input an expiration date (1/31/2007) for all of our
vehicles. Then we have a report based on this table that we want the
expiration date month to be spelled out. How do you take this month and
convert it in the report to say January instead of 1, February instead of 2.
etc.?

Thanks for your help.
 
in an unbound text field, put...

= Format([YourDateField], "MMMM")



Check the help file or try the above. I think I have the syntax correct.
 
Thanks so much for your help. Works great!

Rick B said:
in an unbound text field, put...

= Format([YourDateField], "MMMM")



Check the help file or try the above. I think I have the syntax correct.


doo said:
I have a table that we input an expiration date (1/31/2007) for all of our
vehicles. Then we have a report based on this table that we want the
expiration date month to be spelled out. How do you take this month and
convert it in the report to say January instead of 1, February instead of 2.
etc.?

Thanks for your help.
Click to expand...
Click to expand...
 

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

Date Functions 6
Formatting dates 2
Too Complex Error 5
Multi-level GROUP BY 6
Custom Grouping 3
calculation in Report 1
6 month time bracket in report header 2
Excel Forecasting Dates Out to the Day 3

Back
Top