Date format in table

[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!!!!

 

[Galaxiom]

You need the Date() function instead of Now().

 

[Keith Tedbury]

Just to expand on Galaxiom

Date () gives you just the date

Now () gives you the date and time