topic Re: Error in Script in QlikView

Error in Script

nikhilgarg — Tue, 01 Sep 2015 12:17:57 GMT

Hey,

When i have defined variable as : Let vEndDate = Date(Today(), 'YYYY-MM-DD') ;

and using it as: Date($(vEndDate), 'YYYY-MM-DD') , it is giving me : 1905-06-27 as output. Can someone explain me this absurd behavior?

I ahve attached application also.

Thanks

Anonymous — Tue, 01 Sep 2015 12:22:01 GMT

Hi Nikhil,

You have to lose the $ in the formula.

Try the following:

Date(vEndDate, 'YYYY-MM-DD')

The LET command assigns a value to the variable.

The SET command defines the variable.

As such, the formula with $ would only work if you used the SET command instead of the LET.

Best wishes,

Susana Silva

sasiparupudi1 — Tue, 01 Sep 2015 12:25:22 GMT

the vEndDate is already haviing a formatted date as per your let statement and you do not need to use the date function again.

use the variable directly

vEndDate

'$(vEndDate)'

hth

Sasi

parthakk — Tue, 01 Sep 2015 12:26:16 GMT

Hi Nikhil,

Your vEndDate will be stored in date format itself. Why u need to convert it again to date format?

Thanks,

Partha Kulkarni

nikhilgarg — Wed, 02 Sep 2015 14:15:51 GMT

Hey,

'$(vEndDate)' is working cool but vEndDate will give error bcoz it will treat it as a field.