How to apply Date formatting to column

[BizBoy]

Hi,

I have imported a data from excel in access.
One of the column is 'DOJ' (date of joining).

After importing this data, DOJ was reflecting as number.
Hence I go to Design view and change DOJ formatting to Date/Time.

However, post this, some the records are reflecting as '07/12/2017 15:43:39' with time value.

When I run a query on this data, I get result as '07/12/2017 15:43:39'.
However I need result to populated as '07/12/2017'.
Is it possible. Can anyone please help me in this.

 

[Joe4]

If it just a formatting thing, go to Design View, right click on the Field, and enter mm/dd/yyyy in the Format property of the field (this will only change how it is displayed, not the value).
If you actually need to change the value, then just use the INT function, i.e. INT([DOJ])
This works because Access and Excel store dates as numbers, specifically the number of days since 1/0/1900, and time is just the fraction of a day. So using the INT function removes that fraction (time).

 

[BizBoy]

Hi Joe,

Thanks for the help. I am checking this and will revert with details.
I was not aware access and excel treats dates same way.

Have a nice day ahead.