Extract time with PM/AM

CDPRIN · September 17, 2019, 9:48am

Hi,
I am trying to convert a string with a time and pm/am. I have tried the string to date&time node but none of my suggestion works. Any ideas?

‘[[h:]hh:]mm aa’

AlexanderFillbrunn · September 17, 2019, 10:29am

Hi,
I think the format h:mm' 'a should work for you.
Kind regards
Alexander

CDPRIN · September 17, 2019, 10:44am

Thanks for the tip but don’t seem to work.
Do I have to take into account that hour is both 1 and 2 digits? E.g. [hh:] ?

AlexanderFillbrunn · September 17, 2019, 10:48am

Hi,
I tried it with “7:05 PM”, “11:00 AM”, and “01:18 PM” and all of them work with the pattern above. Did you select “Time” in the “New type” configuration field? What’s your error message?
Kind regards
Alexander

CDPRIN · September 17, 2019, 10:54am

Now it worked, thanks a lot!

system · September 24, 2019, 10:54am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.