M
mdnetessential
I have a table that is created from an imported call log. The call log puts
the date and text into one field...not separately.
For example the resulting field in my new table after an import is "10/12/05
sales meeting went good."
I want to compare todays actual date Date() to the date in the text field.
What's the best way to do this since the date "10/25/05" is sitting in a
text field...not a date field?
the date and text into one field...not separately.
For example the resulting field in my new table after an import is "10/12/05
sales meeting went good."
I want to compare todays actual date Date() to the date in the text field.
What's the best way to do this since the date "10/25/05" is sitting in a
text field...not a date field?