topic Re: Split Date and Time in QlikView

Split Date and Time

parvez933 — Wed, 27 Jan 2021 15:45:49 GMT

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 — Wed, 27 Jan 2021 15:57:21 GMT

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 — Wed, 27 Jan 2021 16:01:26 GMT

Date:

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

Time:

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

sergio0592 — Wed, 27 Jan 2021 16:12:31 GMT

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))