date/time data type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a field in a query where only the month and day needs to
be inserted and I would like a zero placeholder automatically inserted in the
month and/or day when the month or day is 1-9. Is there a way that this can
be accomplished?
Thank you so much!
 
Sue said:
I'm trying to create a field in a query where only the month and day
needs to be inserted and I would like a zero placeholder
automatically inserted in the month and/or day when the month or day
is 1-9. Is there a way that this can be accomplished?
Thank you so much!
Click to expand...

A DateTime will only store a valid date with a year, month, and day. If you
want anything else use a text field.
 
Back
Top