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...
 
Back
Top