topic Re: DATE FORMAT IN A VARIABLE in QlikView

DATE FORMAT IN A VARIABLE

Anonymous — Tue, 23 Oct 2018 10:37:51 GMT

Hello

I have a date format issue,

I want the user to type a date in a variable and then Display it in a text box

In my example attached I type 23/10/2018 and I get 30/12/1899 in the text box

if I type 43031 in the variable it works but it's not what I want 🙂

Thanks a lot

Edouard

mayankraoka — Tue, 23 Oct 2018 10:47:08 GMT

Try this:

date('$(v_date_creation)','DD/MM/YYYY')

regards,

mayank

yoganantha321 — Tue, 23 Oct 2018 11:46:28 GMT

what about

=date(v_date_creation) in text object or try it with other variable

kiran3243 — Tue, 23 Oct 2018 13:45:32 GMT

Hello,

Please find below expression.

=Date(Date#('$(v_date_creation)','DD/MM/YYYY'),'DD/MM/YYYY')

Hope this will work.

Regards,

Kiran Naidu