Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading date field YYYY-MM-DD
An example : 2014-02-10
How can I load date field as YYYYMDD ?
Please dont duplicate the thread..
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField
Please dont duplicate the thread..
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField
Try:
Table:
LOAD * INLINE [
data
2014-02-10
];
t2:
load
Date(data,'YYYYMDD') AS DATE
Resident Table;
Drop Table;
Or
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMDD') as YourDateField
If you need YYYYMDD (assuming it was not a typo)
It should be a typo as
2015115 could be 15th Jan 2015 or 5th November 2015..
No I am wrong... ! It will work as YYYYMDD
I agree
I feel dumb now.
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 |
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