topic Problem with date variable in App Development

Problem with date variable

henninghafr — Tue, 18 Jun 2019 10:43:16 GMT

Hi!

I am a noob regarding databases and I am having trouble with date formatting. I have a variable called "available_from" that seems to be formatted as a string (See picture 1). I am able to convert it into a date by using the input format "YYYY-MM-DD hh:mm[:ss[.ffffff]]" (see picture 2) but my problem is that the dates do not show up when looking at the variable in my Analysis after having reloaded the data (see picture 3). Any suggestion how I can fix this?

Cheers Henning

Re: Problem with date variable

sunny_talwar — Tue, 18 Jun 2019 11:36:58 GMT

What is the exact script you are using to transform the date field?

Re: Problem with date variable

henninghafr — Tue, 18 Jun 2019 11:41:31 GMT

I don't use an actual script but I edit the table (under the data tab) and then click on the variable and change the field type to "date". The I use the input format stated above and "MM/DD/YYYY" as display format. Cheers Henning

Re: Problem with date variable

sunny_talwar — Tue, 18 Jun 2019 11:45:32 GMT

Oh, that might be something new in Qlik Sense. I am not sure how this works. May be someone else can offer there help.

Re: Problem with date variable

henninghafr — Tue, 18 Jun 2019 11:58:30 GMT

Ok!

Thanks anyway!

Re: Problem with date variable

henninghafr — Wed, 19 Jun 2019 13:38:53 GMT

Anyone?

Re: Problem with date variable

Somy — Mon, 19 Aug 2019 23:32:23 GMT

Hi,

Can you attach your excel file?

Re: Problem with date variable

Somy — Mon, 19 Aug 2019 23:37:28 GMT

It's really easy to change the date format by scripting. But if you upload a file which contains a similar data format, Sunny or other professionals may be able to check it and answer your question.