2 Replies Latest reply: Dec 2, 2009 12:10 PM by Erik Pos RSS

    Measure date variable within the script

    Erik Pos

      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,