input mask

paul young

Registered User.
Local time
Today, 02:18
Joined
Aug 15, 2003
Messages
22
I am trying to create an input mask for general date field:
00"/"00"/"00" - "00:00 to give a combination of short date and short time. But the message came back saying 'The value you entered isn't valid for this field'. The only way I can round it is create the field as text. But I prefer the general date so that I can create date sort query later. Please advise, anyone?
 
Try it without the "s

00/00/00 - 00:00

/s and :s are native to date/time formats thus dont need to be "ed

Regards
 

Users who are viewing this thread

Back
Top Bottom