Variable Date as a number in the load script

[tinkerz1]

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?

[swuehl]

Probably because your variable is just a text.

Try

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