Date Format

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

Jason Frazer

I have a field [date1] from table [bridge] with a value of "0503", which is
text. How can i display this in my report to be "May 2003"?

Thanks for your help

Jason
 
Jason said:
I have a field [date1] from table [bridge] with a value of "0503", which is
text. How can i display this in my report to be "May 2003"?
Click to expand...

=Format(DateSerial(Right(date1, 2), Left(date1, 2), 1),
"mmmm yyyy")
 
Back
Top