Date Format

[jblackman]

I have an input mask for date as:
99/99/0000;0;_

For some reason, whent the date is entered, it only displays: 04/01/01 instead of 04/01/2001

Any ideas on how I can get this to behave?

Thanks.

 

[Cgrnc]

Do you have the short date format chosen in the date field for the TABLE where the data is being stored??? If so . . . you need to change this as well.

 

[Rich@ITTC]

Hi J Blackman

What is the Format setting for the text box on the form? If it is ShortDate then it will show 04/01/01.

Depending on where you are you can choose one of these alternatives that you type into the Format property for the text box that displays this date.

mm/dd/yyyy (for USA)

dd/mm/yyyy (for EU and others)

Hope that helps

Rich Gorvin

 

[jblackman]

What I needed to do is to go into my Contrl Panel under Regional Settings and Change the Date from m/d/yy to mm/dd/yy and then it worked like a charm....