PLH
Well-known member
MS Access? [RESOLVED] BY jmcilhinney
Hello all, I hope any one can help me with a little problem I have in my app. My app uses MS Access and I need to sort it by Date and Time. The app uses DataView. It seems that MS Access only stores the date even though I set the format property of data type as a "General Date" which should be in this "02/25/2005 5:45 PM" I don't know why but after saving a new order the date and time looks "02/25/2005" in the actual database. If MS Access date/Time data type stores only date or time what the format property does?
Hello all, I hope any one can help me with a little problem I have in my app. My app uses MS Access and I need to sort it by Date and Time. The app uses DataView. It seems that MS Access only stores the date even though I set the format property of data type as a "General Date" which should be in this "02/25/2005 5:45 PM" I don't know why but after saving a new order the date and time looks "02/25/2005" in the actual database. If MS Access date/Time data type stores only date or time what the format property does?
Last edited: