date/time data type

[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!

 

[Rick Brandt]

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!

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