Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tinkerz1
Contributor II

Variable Date as a number in the load script


I have set a variable called 'Month End Date' and linked it to an input box.

When I enter a date in te input box, 31/08/2015 and enter in the LOAD script num($(Month End Date)) as [Month End]

Why wont this show as a number in a straight table.

I thought QV held dual conditions for dates, everythings gets stored as a number?

1 Reply
MVP
MVP

Re: Variable Date as a number in the load script

Probably because your variable is just a text.

Try

Date#('$(Month End Date)','DD/MM/YYYY') as [Month End]