topic Measure date variable within the script in QlikView

Measure date variable within the script

Wed, 02 Dec 2009 16:55:35 GMT

Dear guru's

I have a problem within the script to compare a date to a variable. I can only get the proper result while using a hard coded date, which is not an option. please advice.

SET

DateFormat='DD-MM-YYYY';

Let

Vandaag=Date(Today(), 'DD-MM-YYYY');

BedrijfOpzeg:

Load

(date([BedrijfLidm Einddat], 'DD-MM-YYYY') < '02-12-2009', 1, 0) as KEY_BedrOpgezegd

// if(date([BedrijfLidm Einddat], 'DD-MM-YYYY') < $(Vandaag), 1, 0) as KEY_BedrOpgezegd

resident BedrijfCommunity; BedrijfLidNummer,

Measure date variable within the script

Wed, 02 Dec 2009 17:02:45 GMT

Hi FJPOS,

try this:



SET DateFormat='DD-MM-YYYY';

LET Vandaag=Date(Today(), 'DD-MM-YYYY');
BedrijfOpzeg:


LOAD

IF(
 date([BedrijfLidm Einddat], 'DD-MM-YYYY') < '$(Vandaag)'
 , 1
 , 0
) as KEY_BedrOpgezegd

Rgds,

Rey-man

Measure date variable within the script

Wed, 02 Dec 2009 17:10:37 GMT

Many thanks, it works now.