Date format issues

[Thecherub]

I'm having problems with my date formats. I've entered into my tables and forms the format of "mmm-dd-yy" I'm assuming that this should display as month (3 digit), Day (2 num), Year (2 num). The problem i'm having is with one of my forms. when i enter the date it displays as Month, year, Day unless i do not enter the year then is diplays as i wish, adding in the current year.

this would be fine if i was working with only the crurrent year. I'm not. I need to be able to enter the correct year. How can i fix this?

 

[doran_doran]

These database has all type date format samples.

check it out and keep this sample database for future reference.

Good Luck.

 

[Thecherub]

Thanks

check it out and keep this sample database for future reference.

Good Luck.

Thank you that sample base will be a great help in the future. I figuered out how to fix my entry problem without it. for some reason (i don't know why) if I enter the dates as Month, year, day, everything works. the form reorders it as Month, day, year and then it feeds correctly into the queries.

I don't know all i care about right now is my headaches are over.

Hey Mile Maybe Jamils Database should be saved in the samples.

Thank you everyone for all the help I have learned alot in the past few months and now have some more dangerous knowledge

 

[Mile-O]

Hey Mile Maybe Jamils Database should be saved in the samples.

There's nothing to stop her posting it there if she wants to.