General discussion


Date Formats In Access 2000

By cbremar ·
I am trying to a make a date (04/03/03) - month, day, year - that is typed into a text box on an Access form be saved to the table in a different format (030304) - year, day, month.

Is there anyone out there that can help me?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

wrong forum

by john_wills In reply to Date Formats In Access 20 ...

This question belongs in Technical Q & A. As it happens, I know the answer.

Collapse -

What's the answer?

by cbremar In reply to wrong forum

So, what's the answer?

Collapse -


by JackOfAllTech In reply to Date Formats In Access 20 ...

Assuming you want to store the date as a string...

sNewDate = Format(DateValue(sOldDate), "yyddmm")


Collapse -

by saqibmabbasi In reply to Date Formats In Access 20 ...


Suppose that the data is saved in the database when you press a button. then what you can do is
in the button click event use the format function as follows

someString = format(yourDate, newFormat)
here "yourDate" is the date that isentered.
newFormat is the format you want to save the data in like "yyddMM".

and someString is just to assign the date into a variable then save. you can also save the date directly without assigning it to a variable.

hope this helps.

Related Discussions

Related Forums