Format Conversion

  • Thread starter NeonSky via AccessMonster.com
  • Start date
N

NeonSky via AccessMonster.com

Good Day,

How is everyone today?

Quick question, how do I run an update to convert date values to the
following format: from "5/11/2008" to "11-May-08" ?

Thank you!
 
M

Michel Walsh

Format( yourDate, "dd-mmm-yyyy")


or


Format( yourDate, "dd-mmmm-yyyy")




as in:

? Format(now, "dd-mmm-yyyy")
05-Sep-2007

? Format(now, "dd-mmmm-yyyy")
05-September-2007



Hoping it may help,
Vanderghast, Access MVP
 
K

KARL DEWEY

You do not UPDATE if it is a date field.

You just format the display output.
 
Top