topic Re: convert year format in script in QlikView

convert year format in script

markgraham123 — Thu, 21 Sep 2017 14:01:34 GMT

Hi All,

I have date format as 3/15/0017 11:52:58 PM in my data set.

I wanna see it as 3/15/2017 11:52:58 PM

Can someone please help?

Re: convert year format in script

antoniotiman — Thu, 21 Sep 2017 14:19:51 GMT

Hi Mark,

may be

Timestamp(Timestamp#(Date,'M/D/00YY hh:mm:ss TT'),'M/D/YYYY hh:mm:ss TT')

=Timestamp(Timestamp#('3/15/0017 11:52:58 PM','M/D/00YY hh:mm:ss TT'),'M/D/YYYY hh:mm:ss TT')

Regards,

Antonio

Re: convert year format in script

markgraham123 — Thu, 21 Sep 2017 14:37:59 GMT

This is not working for all fields Antonio.

Actual data set is like this - Combination of normal and other data type!

3/15/0017 11:52:58 PM

3/16/2017 11:52:58 PM

3/17/0017 11:52:58 PM

3/18/2017 11:52:58 PM

3/19/0017 11:52:58 PM

3/22/2017 11:52:58 PM

3/23/2017 11:52:58 PM

3/30/2017 11:52:58 PM

Re: convert year format in script

antoniotiman — Thu, 21 Sep 2017 14:42:53 GMT

LOAD Alt(Timestamp(Timestamp#(Date,'M/D/00YY hh:mm:ss TT'),'M/D/YYYY hh:mm:ss TT'),Timestamp(Timestamp#(Date,'M/D/YYYY hh:mm:ss TT'),'M/D/YYYY hh:mm:ss TT')) as Date

Re: convert year format in script

vishsaggi — Thu, 21 Sep 2017 14:43:53 GMT

Write an IF condition with Antonio's timestamp function.

Like:

= IF(Left(Subfield('31/02/0017', '/',3), 2) = '00', Timestamp(Timestamp#('3/15/0017 11:52:58 PM','M/D/00YY hh:mm:ss TT'),'M/D/YYYY hh:mm:ss TT') , yourdatefield)