API Date Time Format Said, "Huh?"

[paullefrancois]

I hope everyone's New Year is kicking last year's January 10th's BUTT!!!

I'm seeing a new date time string value coming in as "PT1H8M42.622S" (without quotes of course) and would appreciate assistance tackling this one.

The end result would be a capture of time. 

Thank you in advance!  

Paul

[Qiu]

@paullefrancois 
What is the name of your API or the target application?

[Luke_C]

Hi @paullefrancois 

I'm reading it as 1:08:42 Pacific Time (no date, just timestamp). Does this make sense with what you're expecting? What are you trying to do with it in your workflow?

[Qiu]

@Luke_C 
nice one!

[paullefrancois · Accepted solution]

Hello Qiu,

I'm connecting to NICE (CXOne). 

Thank you very much,

Paul

[paullefrancois]

Reading the string visually wasn't really an issue. I was more looking for assistance with parsing the string out in an Alteryx workflow. 

[Luke_C · Accepted solution]

Hows something like this? @paullefrancois 

datetimeparse([Field1],'PT%HH%MM%S')