Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
new2qlik
Contributor III
Contributor III

How do I get my date format from this to this?

I'm trying to pull raw data and format the dates according to the format the script is in. I have tried copying script xml, but no luck. I'm trying to work off an existing script in qliksense or create a new one since I can't edit old one.

My date formats raw data are like this:

15060606

19032203

My finished script date are like this:

24-Jun-15

22-Mar-19

The script xml code are:

<BitOffset>118</BitOffset>
<BitWidth>10</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>DATE</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt>DD-MMM-YY</Fmt>
<Dec></Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>974</NoOfSymbols>
<Offset>1759010</Offset>
<Length>4870</Length>
<Comment></Comment>
<Tags></Tags>

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

Not 100% clear what you mean

but if you want to convert
19032203 to 22-Mar-2019 and 15060606 to 06-Jun-2015

use something like below

Date(Date#(left(YOURFIELD, 6),'YYMMDD'),'DD-MMM-YYYY')

dplr-rn
Partner - Master III
Partner - Master III

Close the thread as answered if it helped