How to filter a column in Access?

Question

I have a Table in Access.
In a column of the table there are data for date and time combined with the following format: YYYY.MM.DD hh:mm:ss
For example 09.03.2006 12:35:12
I need to convert this column into YYY.MM.DD only, that is, to take out the time stuff. How can I do that??

Answer 1

- Go into the design mode of the table.
- Select the Field with the Date information you want to change
Note - The field should be a Date/Time type
- At the Bottom of the screen is the details of the field
- In the "Format" area you can set out how you wish the date to be viewed.

OR

Create a query with all the data in the table but instead of this date field, create a new one that looks something like this

New Date: Format([Date Field], "yyyy.mm.dd")

but if you do this the field will be considered a String and not a Date. (That may cause issues if you wish to do something else with the data)

Answer 2

Go in to design mode of the table. click on the date column. in the lower partof the screen you will see property for the column highlighted. you can set input mask to convert in to the format that you need.

Good luck!!!!!!!!

Answer 3

export the table into excel and re format the column if you do this in access you will lose the data in it :)