Date field

  • Thread starter Thread starter John
  • Start date Start date
J

John

I need a date field in a digits form so for example
3/12/2004, I need to be 03122004. Does anyone have a
formula or way already in a query to be able to take any
date whether it is eight characters (EX: 3/3/2004), nine
characters (EX: 10/3/2004) or ten characters (EX:
10/19/2004) and convert it to an eight digit field.

Thanks in advance
John
 
If you need leading zeroes, then this will have to be a STRING field. Number
fields cannot hold leading (or trailing) zeroes.

Field: SpecialDateFormat: Format(TheDateField,"mmddyyyy")
 
Back
Top