MS Access Date/Time Not Working

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

dphilton

Thread Starter
Joined
Oct 29, 2007
Messages
1
Last week in a database I was developing I had 2 Date/Time fields set with General Date format. It was working perfectly last week where I would type in 10/24 12a and it would expand it out to 10/24/2007 12:00 AM for me.

Fast forward to today and it is now only recording the Date and not the time. I have changed nothing and on a rare occasion can get it to recognize the date and time in the datasheet view but never from the form.


Anyone else ever witness this and know the fix?

Thanks

DPH

Edit: Well I found what I believe is the issue.

If I type 10/26 11p it will convert to 10/26/2007 11:00 PM so the user can short hand the entry.
If I type 10/26 12a it will only show the date. So 1 minute around the entire clock will error.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top