Conversion of date/ time fields

[GerryWiles]

I have adatabase which daily imports data from a spreadsheet to a
named table. The spreadsheet contains one filed which is date AND time
whereas in the table I have one field being date which is formatted
to short date,.The data looks OK in the table with only a date showing
but wen I examine the date field I can expand it to see also the time.
This is causing some problems with other routines using the table.
Can anybody advise how I can actually REMOVE the time details from the
field so that I have only a date field ?

Thank you
Gerry

[Allen Browne]

Use an Update query to remove the time part of the field.

Example:
UPDATE Table1
SET Field1 = DateValue(Field1)
WHERE Field1 Is Not Null;

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GerryWiles" <ge***@colvan.co.ukwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...

>I have adatabase which daily imports data from a spreadsheet to a
named table. The spreadsheet contains one filed which is date AND time
whereas in the table I have one field being date which is formatted
to short date,.The data looks OK in the table with only a date showing
but wen I examine the date field I can expand it to see also the time.
This is causing some problems with other routines using the table.
Can anybody advise how I can actually REMOVE the time details from the
field so that I have only a date field ?

Thank you
Gerry

[OldPro]

On Oct 3, 5:52 am, "Allen Browne" <[e-mail]:

Use an Update query to remove the time part of the field.

Example:
UPDATE Table1
SET Field1 = DateValue(Field1)
WHERE Field1 Is Not Null;

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GerryWiles" <[e-mail] in message

news:11**********************@22g2000hsm.googlegro ups.com...

I have adatabase which daily imports data from a spreadsheet to a
named table. The spreadsheet contains one filed which is date AND time
whereas in the table I have one field being date which is formatted
to short date,.The data looks OK in the table with only a date showing
but wen I examine the date field I can expand it to see also the time.
This is causing some problems with other routines using the table.
Can anybody advise how I can actually REMOVE the time details from the
field so that I have only a date field ?

Thank you
Gerry- Hide quoted text -

- Show quoted text -

Or, you could just format it for date. format(myDate,"mm/dd/yy") or
select "Short Date" in format property.