szadroga
asked on
convert short text to date value
I am querying a linked table in MS Access and the field values are all text. I want to do a calculation to determine the time difference between now() and opened_at. The opened_at field has a value of 01-26-15 3:15 PM EST in text format. How can i convert this to date so the calculation can be made?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Look again at Rey's suggestion. You have to get rid of the "EST" part of the string in order to have something Access will recognize as a valid date/time value.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
my mistake, that was it. thx for catching that
You are welcome!
/gustav
/gustav
ASKER
i meant to split the points assignment. can this be done now?
Yes. Call for attention.
/gustav
/gustav
ASKER