Extract Date out of General Date

[Kil]

I have a series of rows that resemble 6/1/2006 5:34:34 PM type of
format.

However, I would really only like the extract out the 6/1/2006 portion
of this date. I have used left(fieldName,9) but this wouldn't work too
well if the month was a double digit, or if I left it as 10, it would
grab a portion of the hour in time.

Is there a work around for this? I have searched and attemped but am
at a loss now.

Thank you.

 

[Duane Hookom]

Use DateValue([date field name])