Split Date and Time

[parvez933]

Hi!

Please help, how can I split the data and time from the below format

2021_01_25_03_20_11

2021_01_25_03_20_12

2021_01_25_03_20_13

2021_01_25_03_20_14

2021_01_25_03_21_13

Regards,

M. Parvez

[skamath1]

Try the functions Date# and Time# 

Below is the sample script 

Load Date(Date#(Left(DateTime,10),'YYYY_MM_DD')) as DatePart,
Time(Time#(Right(DateTime,8),'hh_mm_ss')) as TimePart ;

Load * Inline
[
DateTime
2021_01_25_03_20_11
2021_01_25_03_20_12
2021_01_25_03_20_13
2021_01_25_03_20_14
2021_01_25_03_21_13
] ;

[Vegar]

Date:

Dayname(timestamp#([Your Field], 'YYYY_MM_DD_hh_mm_ss'))

Time:

Time(Frac(timestamp#([Your Field], 'YYYY_MM_DD_hh_mm_ss')) ) 

[sergio0592]

Hi,

Try with date:

=MakeDate(subfield(Date,'_',1),subfield(Date,'_',2),subfield(Date,'_',3))

Time

MakeTime(SubField(Date,'_',4),SubField(Date,'_',5), SubField(Date,'_',6))