Date Format Different in same column

[drunkenneo]

I have a table having column as date, format as mm/dd/yyyy and i update the column as now() using VBA.



However some places the date is in mm/dd/yyyy and in some mm/dd/yyyy nn:mm:ss are appearing which is making the filtering of the data ambuige.

Please Help.


Happy New Year!!!!

[amrut]

Try using Date() instead of Now()

[June7]

Midnight will show as mm/dd/yyyy because the time part is 0:0:0. A date value is actually stored as a double number. The decimal part is the time. So the decimal for midnight is 0 and Access does not display 0 decimal.

As amrut says, if you don't want time parts then use Date().