K
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.
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.