topic Conversion date from YYYY-MM-DD to YYYYMMDD in QlikView

Conversion date from YYYY-MM-DD to YYYYMMDD

Anonymous — Wed, 12 Aug 2015 08:48:43 GMT

I am loading date field YYYY-MM-DD

An example : 2014-02-10

How can I load date field as YYYYMDD ?

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

MK_QSL — Wed, 12 Aug 2015 08:57:22 GMT

Please dont duplicate the thread..

Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

robert_mika — Wed, 12 Aug 2015 08:58:16 GMT

Try:

Table:

LOAD * INLINE [

data

2014-02-10

];

t2:

load

Date(data,'YYYYMDD') AS DATE

Resident Table;

Drop Table;

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

sunny_talwar — Wed, 12 Aug 2015 08:58:51 GMT

Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMDD') as YourDateField

If you need YYYYMDD (assuming it was not a typo)

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

MK_QSL — Wed, 12 Aug 2015 09:01:28 GMT

It should be a typo as

2015115 could be 15th Jan 2015 or 5th November 2015..

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

MK_QSL — Wed, 12 Aug 2015 09:03:11 GMT

No I am wrong... ! It will work as YYYYMDD

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

sunny_talwar — Wed, 12 Aug 2015 09:03:14 GMT

I agree

I feel dumb now.

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

MK_QSL — Wed, 12 Aug 2015 09:04:28 GMT

YYYYMDD will work but YYYYMD will not !

Load

Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField1,

Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMDD') as YourDateField2,

Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMD') as YourDateField3

Inline

[

YourDateField

2015-01-15

2015-11-5

];

YourDateField1	YourDateField2	YourDateField3
20150115	2015115	2015115
20151105	20151105	2015115

Re: Conversion date from YYYY-MM-DD to YYYYMMDD

Sarah_Miller — Thu, 13 Aug 2015 15:33:57 GMT

Greetings

Thanks for your post in Qlik Community. I have moved your post to the App Development sub community. Based on the content of your post I think it will be visible to more members in the new location.

The Education group is only for questions related to training, certification, and any programs we offer.

Thank you,

Sarah Miller