Converting String to Date in 8.5

[davidmo]

I am trying to convert string data into date/time. Not sure how.

 

[vidru]

What format is your string? Is it always in the same format?

Since you didn't specify what the string looks like, it's a little difficult to supply you with an answer.

That being said, essentially what you'll have to do is parse out the information and pass it to one of the DateTime functions, which come in 3 flavors:

DateTime (date, time)
DateTime (YYYY, MM, DD)
DateTime (YYYY, MM, DD, HH, MM, SS)

 

[davidmo]

The format of the string is mm/dd/yyyy and it is always the same.

 

[vidru]

OK, then try a formula like this:

DateTime (Date({Table.DateField}), Time (00, 00, 00))

The time portion will be 12:00:00 AM.

-dave