Format Date in Calculated Feild

[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

 

[Allen Browne]

Use the Format() function:

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

 

[Dee]

Thanks Allen!!

Dee

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")

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