Problem with date conversion

[#1]

Hi Experts,

I have a list box Yearmonth which i haved attached below.My requirement is to show  Date in  TextBox in MM/DD/YYYY format when i click a date in listbox.

Regards

Tripati

[sunny_talwar · Accepted solution]

I think you need to fix your date field in the script. You can try something like this

Date(Num#(YearMonth), 'YYYYMM') as YearMonth

Read more about how to get dates correctly in QlikView here:

Get the Dates Right‌

Why don’t my dates work?