Is it possible to turn a string format into a date format?
we have a date but it is a string and I need it to be a date so I can get the difference between two dates.
lclayton (BOB member since 2010-01-21)
Is it possible to turn a string format into a date format?
we have a date but it is a string and I need it to be a date so I can get the difference between two dates.
lclayton (BOB member since 2010-01-21)
todate function is specifically made for this purpose.
BO_Stuffed (BOB member since 2008-03-29)
Worked like a charm - thank you
lclayton (BOB member since 2010-01-21)
Hi, in the future please choose a descriptive subject for your post. I have edited this one to make the question more clear, thanks.
Dave Rathbun (BOB member since 2002-06-06)
=FormatDate(ToDate([object name]);; M/d/yyyy hh:mm:ss A); MM/dd/yyyy)
harrypintous (BOB member since 2010-02-05)