Convert date time and timezone

[userid128223]

How do you convert below to date & time separately.

2017-11-20T01:30:00-05:00

Output:

Date: 2017-11-20

Time: 01:30

Thanks

[Anil_Babu_Samineni · Accepted solution]

I will go with this?

Date = Left('2017-11-20T01:30:00-05:00' ,10)

Time = Left(SubField('2017-11-20T01:30:00-05:00' ,'T', -1), 5)

[Anil_Babu_Samineni]

Or, Simplest way to achieve

=Date(Timestamp(ConvertToLocalTime('2017-11-20T01:30:00-05:00')), 'YYYY-MM-DD')

[its_anandrjs]

For Date do this way

=Date(Left('2017-11-20T01:30:00-05:00',10))

For Time do this way

=Time( Mid('2017-11-20T01:30:00-05:00',12,5))