topic Re: How do I get my date format from this to this? in App Development

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

new2qlik — Mon, 25 Mar 2019 17:31:09 GMT

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:

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

dplr-rn — Mon, 25 Mar 2019 18:53:24 GMT

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

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

dplr-rn — Tue, 26 Mar 2019 20:06:17 GMT

Close the thread as answered if it helped