How to delete characters from the right

  • Thread starter Thread starter Tim Wilson
  • Start date Start date
T

Tim Wilson

I'm looking for a delete function or something within the
date function that will strip out the year in a date

example: 01/16/2004 becomes 01/16

Any help would be greatly appreciated. Thank you.
 
You can format a date field to display only month and day by using the
Format() function:

Format([MyDateField], "mm/dd")

hth,
 
In Access Help, look up "User-defined formats" > See
Also "User-defined Date/Time formats (Format function).

if Date1 = 01/16/2004.....

MyField = Format(Date1,"mm\/dd")

should result in 01/16
mm - show 2 digit month
\ - show the following character as a literal character.
dd - show 2 digit day

jmonty
 
Back
Top