Trim date format

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

Guest

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