S
Scott
I have a text field with the following data in record one.
Added 8/5/2009 2:57:08 PM For 8/4/2009
The field in record two has the following data.
Added 12/19/2009 3:08:49 PM For 12/18/2009
What is the query syntax to extract the first date and time in the field? I
will then use an update query to write the first date and time in the field
to a different field.
What is the syntax to extract the second date from the field? I will then
use the update query to write the second date in the field to a different
field.
Basically, I'm looking to create two fields from the one, with the first
date and time as one field and the second date as one field. I will drop the
text values and only extract the date value. Notice that some of the dates
have two digit months and years and some have one digit months and years.
Thank you,
Scott
Added 8/5/2009 2:57:08 PM For 8/4/2009
The field in record two has the following data.
Added 12/19/2009 3:08:49 PM For 12/18/2009
What is the query syntax to extract the first date and time in the field? I
will then use an update query to write the first date and time in the field
to a different field.
What is the syntax to extract the second date from the field? I will then
use the update query to write the second date in the field to a different
field.
Basically, I'm looking to create two fields from the one, with the first
date and time as one field and the second date as one field. I will drop the
text values and only extract the date value. Notice that some of the dates
have two digit months and years and some have one digit months and years.
Thank you,
Scott