Date and time

[Gowtham174]

Hi All,

Can you please help me to split the date and time into two difference column.

Input:

Local Start Time

2018-06-16T23:29:58.567

Output expected:

Date column:

16/06/2018

Time column:

23:29:58.567

Thanks,

Gowtham

[ChennaiahNallani]

try like below.

[paola_valenti]

Do you want "Date column" having only format as Date, or also numeric value without the hour part?

(and "Time column" containing only Time value, without data numeric value, or is only a format problem?)

If you want to separate numeric value of data+hour in 2 column you can use Floor and Frac function

Date column

Date(Floor(Date#('2018-06-16 23:29:58.567','YYYY-MM-DD hh:mm:ss.fff')))

Time Column

Time(Frac(Date#('2018-06-16 23:29:58.567','YYYY-MM-DD hh:mm:ss.fff')))

[paola_valenti · Accepted solution]

[ahmar811]

Hi,

Please find below expression for Date and Time

Date

Expression =Date(Date#(SubField('2018-06-16T23:29:58.567','T',1),'YYYY-MM-DD'),'DD/MM/YYYY')

Time

Expression=Time#(SubField('2018-06-16T23:29:58.567','T',2),'HH:MM:SS.mm')

I hope this will help you

Regards

Ahmar