Date format

[Lasius]

Hi,

I want to type a date in a access table. The table has a column formated as date. Then I type in the following date: 14.08.03 07:44:29 it works fine.
But then I try 14.08.03 00:00:00, Access cuts the time and it looks like 14.08.03. But I want the time to be display. Does anybody know a solution ?

Thanks a lot

Thomas

 

[PaulBricker]

Well, here's the reason but not a solution. DateTimes are stored as Double Precision values. The value 14.08.03 00:00:00 = 37847.000000000
so Access, in it's infinite wisdom return
37847 which displays as
14.08.03

Paul