Date Format

[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

 

[Marshall Barton]

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

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

 

[Fredg]

Jason,
Format(DateSerial(Right([Date1],2),Left([Date1],2),1),"mmm yyyy")