Is it possible to turn a string format into a date format?

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 :us: (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)