Updating Date Field

[ebizleads]

I have some values in my date field that include the time of the record...need to clean this up. Would like for the format to be:

MM/DD/YY

How would I update this field to do this?

Thanks,

EbizLeads

 

[PHV]

UPDATE yourTable
SET [your date field] = Int([your date field])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

Good (yet subtle) lesson on how date values are stored.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]