date field

[Guest]

I need to enter a date but it will be year,month,day ex: 07/06/26. How do I
put this in the input mask? Thanks in advance.

 

[Guest]

Hi Annette

I would suggest you don't use an input mask for this as it may be a problem
with dates after/before 2000. If you have 2 dates 12/12/1907 and
12/12/2007 you would have a problem. Of course at the moment this may not be
a problem but it will be as the years go by, so you'd be best to build your
database to last as long as possible.

I would suggest using a normal input mask for the date like this
00/00/0000;0;_
which will give 12/12/2007 or 12/12/1907

and then use the format option so only the last 2 numbers of the year are
shown like this dd/mm/yy (or if in US mm/dd/yy)

Hope this helps

 

[Guest]

Wayne,

Thank you very much. I will try that. Someone else designed the form and I
have to make some changes. When you type in the date field it comes up with
the /. How would I do this?

 

[Guest]

Hi Annette

You can use 00/00/0000;0;_ and the forward line will go in for you. Or you
can set the format yourself and add them where you want

dd/mm/yyyy
or
mmmm-dd/yy
or
dd.mm.yyyy
etc
etc
etc

 

[Guest]

Wayne,

Thank you very much. Have a great day!!!

Annette