Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

DATE FORMAT IN A VARIABLE

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

3 Replies
mayankraoka
Specialist
Specialist

Try this:

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

regards,

mayank

yoganantha321
Creator II
Creator II

what about

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

kiran3243
Contributor II
Contributor II

Hello,

Please find below expression.

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

Hope this will work.

Regards,

Kiran Naidu