Format Date in Calculated Feild

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

I have a calculated field that I would like to format the date to be mmmm
yyyy:

="Report Period from: " & [Enter Start Date] & "Through " & [Enter End
Date]

I would like for those dates to be formatted as mmmm yyyy. How can I do
that? Right now, I have separated the expression out into 4 fields because
I couln't find any information on how to do it. (Or I don't know the best
place to look).

And I am working trying to get those two questions and one more prompt about
Requesting Rep Number in one prompt or message box.... instead of three
annoying ones.

Thanks everyone for any help you can provide :)!

Dee
 
Use the Format() function:

="Report Period from: " &
Format([Enter Start Date], "mmmm yyyy") &
" Through " &
Format([Enter End Date], "mmmm yyyy")
 
Thanks Allen!!

Dee


Allen Browne said:
Use the Format() function:

="Report Period from: " &
Format([Enter Start Date], "mmmm yyyy") &
" Through " &
Format([Enter End Date], "mmmm yyyy")


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")
Dee said:
I have a calculated field that I would like to format the date to be mmmm
yyyy:

="Report Period from: " & [Enter Start Date] & "Through " & [Enter End
Date]

I would like for those dates to be formatted as mmmm yyyy. How can I do
that? Right now, I have separated the expression out into 4 fields because
I couln't find any information on how to do it. (Or I don't know the best
place to look).

And I am working trying to get those two questions and one more prompt about
Requesting Rep Number in one prompt or message box.... instead of three
annoying ones.

Thanks everyone for any help you can provide :)!

Dee
Click to expand...
Click to expand...
 
Back
Top