advanced query null date selection

advanced query null date selection

  

Hi Guys,

   I am trying to filter only null dates on advanced query but unsucessful. Someone know how to do it ?

Every time I try to use this syntax I receive no rows message: 

SELECT {Planning}.[Summary] FROM {Planning}
WHERE  {Planning}.[EndDate] is null


Thanks for any tip

Luck

Solution

Hello Luciano,


I'm not completely sure what the problem may be, but perhaps the records you are trying to find do not really have a null date but OutSystems Platform default date value instead, which is 1900-01-01 00:00:00 (see Default Values in Database). So, please try the following query instead to see if you can obtain those records:


SELECT {Planning}.[Summary] FROM {Planning}
WHERE  {Planning}.[EndDate] = '1900-01-01 00:00:00'
Solution

Yeap Paulo,

   you are right. I didn´t know that advanced query behaviour was the same for aggregation at this point. 

Thanks so much


Luck