Trim date format

K

KAnoe

I have a report that I use a trim text box on the page header, Here it is.

=Trim("Permit Report for " & [P_Mo])

The [P_Mo] is a date. I would like it to be in MMM YYYY format. How can I do
that in the Trim code.

Thanks

Keith
 
K

KAnoe

Thanks Allen!!

Now that I see it I think *&# I should have got that!!

Thanks Again!

Allen Browne said:
Try:
="Permit Report for " & Format([P_Mo], "mmm yyyy")

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

Reply to group, rather than allenbrowne at mvps dot org.

KAnoe said:
I have a report that I use a trim text box on the page header, Here it is.

=Trim("Permit Report for " & [P_Mo])

The [P_Mo] is a date. I would like it to be in MMM YYYY format. How can I
do
that in the Trim code.

Thanks

Keith
Click to expand...
Click to expand...
 
Top