Date Format

[Anonymous]

Hi,

I have a date field like 2016-01-27T19:04:00.251-06:00

i want to retrieve the time hh:mm:ss from this field.

Thank you

[sunny_talwar]

Try using TextBetween as Mindaugas Bacius‌ showed below

=Time(Time#(TextBetween('2016-01-27T19:04:00.251-06:00', 'T', '.'), 'hh:mm:ss'), 'hh:mm:ss')

[MindaugasBacius]

Could you than share the rules according to what the Time should appear?

Or can you share all available possibilities of that date field?

[krishna20]

Hi ,

Try This in script

Timestamp(Dual(SubField(Column1,'T',2),Time#(SubField(Column1,'T',2),'hh:mm:ss.fff-ff:ff')),'hh:mm:ss')