Measure date variable within the script

[#1]

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

if

(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,

[#2 · Accepted solution]

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

[#3]

Many thanks, it works now.