Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,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
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
Many thanks, it works now.