Date Field

C · Sep 17, 2003

How do I retrieve certain elements from a date field?
E.g. I need 091703 from a date field input of 9/17/2003.

Douglas J. Steele · Sep 17, 2003

If the value's been stored in a Date field, use the Format function to
reformat it:

Format$(MyDate, "mmddyy")

Larry Daugherty · Sep 17, 2003

format(MyDate, "mmddyy")

hth