input mask for Date/Time

  • Thread starter Thread starter jrlh
  • Start date Start date
J

jrlh

I need to set up an input mask for a Date/Time data type
such that it will accept a year only if the month and day
are not available (e.g., __/__/1990). I've tried using
the 99/99/0000 input mask, but it will not accept spaces
for the month and year. If I use a Text data type with a
99/99/0000 input mask, then it will accept spaces but I
lose the ability to limit the month between 01 and 12, and
the day between 01 and 31. Do you have any suggestions?
I'm at a loss!

Thanks!

Jennifer
 
Jennifer

It is not possible to enter a date without all components: day, month,
and year.
 
Back
Top