Date Format

[Guest]

I have a date in a table and the format is "short date" and the input mask is
"99/99/0000" - I want to change the date from - example: 10/22/2004 to
10/22/04. What do I change? I changed the input mask to 99/99/00 and it
didn't change.

HELP - Thanks

 

[RobFMS]

Do you want to change it for both the table and form?
Although you type in the form 10/22/04, the table knows that it needs to
show it as 10/22/2004 when you open the table.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Guest]

Thank you for your help Rob - The date format in the form is 10/22/2004.
I want to be able to type it 10/22/04 in the form as well.

 

[RobFMS]

Make sure the input mask on both the form and the table is set for 99/99/00
and the format is "Short Date".
Let me know what you find out afterwards.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[NataliaNatalia]

I changed the form and the table and I still have the
10/28/2004 date.

HELP!

 

[Douglas J. Steele]

"Short Date" picks up its format from Regional Settings. If you've set it to
4 digit year there, then you'll get it everywhere. To get only a 2 digit
year, change the format to mm/dd/yy. (Of course, I seem to recall some sort
of flap a few years ago about problems with only using 2 digit years.
Something about Y2K, or something like that. <g>)