year - 2 digits

[eran185]

hey
i have table.
it's define as a Short Date (XX/XX/XXXX)
i want that my date will be like this : XX/XX/XX
how can i define the date ?

 

[RuralGuy]

First of all, dates are always stored the same way. Here's a link that explains the DateTime field a little better. http://support.microsoft.com/default.aspx/kb/q130514/
Having said that, you can display the DateTime field any way you wish with the Format() function. Format([YourDateField],"mm/dd/yy")

 

[missinglinq]

i have table.
it's define as a Short Date (XX/XX/XXXX)
i want that my date will be like this : XX/XX/XX
how can i define the date ?

RuralGuy's advice about using Format is spot on; it allows a great deal of handy manipulation for dates/times, but I'm confused! A Date field defined in a table as a Short Date is not (XX/XX/XXXX) but rather (XX/XX/XX) which is what you stated you wanted! What kind of difficulty are you having?

 

[boblarson]

A Date field defined in a table as a Short Date is not (XX/XX/XXXX) but rather (XX/XX/XX) which is what you stated you wanted!

Negative on that missinglinq. The date is actually stored in the table as a double (number) and Short Date is the formatting that is defined in regional settings on your computer. You can define it to be whatever you want (provided it returns a valid date format). The default shortdate format for Windows is now X/X/XXXX.

 

[missinglinq]

The default shortdate format for Windows is now X/X/XXXX.

Not if you're still running Windows 98SE! I sometimes forget that time is passing me by!

 

[boblarson]

Not if you're still running Windows 98SE! I sometimes forget that time is passing me by!

Of course I wasn't talking about dinosaurs

 

[missinglinq]

And I thought Oregon was home to the Prehistoric Gardens!

 

[RoyVidar]

I'd be careful with short date = short date, as where I reside, it looks like this in Win XP dd.mm.yyyy.

Though, on my Win95 and 98 it's dd.mm.yy.

So - it might be localized, too, in addition to other oddities

 

[missinglinq]

Another dinosaur! Is it true you have anti-freeze reservoirs for your PCs over there