DateTimeParse

[tessaenns]

Hello,

I am trying to parse a field called "checkintime", it is a date time field, but coming through as a V_W string. For example, the value looks like "2020-01-01 06:05:48" and I want one field for date and one field for time.

Please advise on best practices, thank you.

[MarqueeCrew · Accepted solution]

Hi @tessaenns ,

You'll want to have two formulas (within one tool)

DATE_Component (DATE)

Left([Field],10)

TIME_Component (TIME)

Right([Field],8)

Cheers,

Mark

[tessaenns]

That worked, thank you for your quick response! Stay tuned, I have one more question. 🙂