trim

[iuphim]

Hi, how do I trim a date to this format mm/dd/yyyy.

My current date is in this format mm/dd/yyyy hh:mm:ss.

Thanks!

 

[pbaldy]

Depends on what you're trying to do. Options include the DateValue() and Format() functions. If you're trying to actually change the data, you could use an update query.

 

[iuphim]

Depends on what you're trying to do. Options include the DateValue() and Format() functions. If you're trying to actually change the data, you could use an update query.

How do I do any of that especially the update function?

Thanks!

 

[Perissos]

In Update to use:

Format([DateFieldName],"mm/dd/yyyy")

 

[pbaldy]

The update query would look something like:

UPDATE TableName
SET FieldName = DateValue(FieldName)

Make a backup first, in case something goes horribly wrong.