compare dates

Hi, i write this select:

select count(RecId) from _table

where _table.Dimension1 == tirCarnetTable.Dimension1 &&

_table.Pages == GIR_TIRCarnetPages::Pages4 &&

_table.IssuedDate == null &&

_table.SendDate == null;

And It says error by dates(cannot compare those types). So how to compare date with null?


Hi Kestutis,

DateNull for the date can be given in 2 ways:

  1. Global::DateNull()
  2. or like this
    if (endDate != mkdate(1,1,1900)

Thanks a lot, it works. I coudnt find that by google :slight_smile:

pls verify if it works