P
psifreak
Guest
Hello,
Topic about says it all. Im trying to query something I set up in the database as a Date/Time field with the Medium Time format selected. I couldnt figure out why it was working, so I plugged in a readout. A field that displays its entirety in Access as "12:15 PM" queried as "12/30/1899 12:15 PM" How do I get rid of the "12/30/1899" altogether from this field? Ive a field for the dd/mm/yyyy dates, should I worry about that sticking a time stamp in there for hours and minutes too? Its set to Medium Time because that one showed me the AM and PM status.
Bonus thanks if you can tell me how to make it quit defaulting to over a hundred years ago on the date in the first place.
May the fleas of a thousand camels feast happily on the lower regions of your enemies. And may their arms be too short to scratch!
Continue reading...
Topic about says it all. Im trying to query something I set up in the database as a Date/Time field with the Medium Time format selected. I couldnt figure out why it was working, so I plugged in a readout. A field that displays its entirety in Access as "12:15 PM" queried as "12/30/1899 12:15 PM" How do I get rid of the "12/30/1899" altogether from this field? Ive a field for the dd/mm/yyyy dates, should I worry about that sticking a time stamp in there for hours and minutes too? Its set to Medium Time because that one showed me the AM and PM status.
Bonus thanks if you can tell me how to make it quit defaulting to over a hundred years ago on the date in the first place.
May the fleas of a thousand camels feast happily on the lower regions of your enemies. And may their arms be too short to scratch!
Continue reading...