Null Date behaviour

[Chris_Ransom_(Guest)]

If I create a Calculated value from a datetime field using the TODATE() function in a report and then try to filter out records where it contains Null values it doesn^t seem to work. However if I try to filter out Null values using the original database field it does. i.e. Calculated field Date_Cancel contains TODATE(DATECNCL). If I add a filter condition to include records where Date_Cancel is not Null it still ignores them. However if I ask in to include records where DATECNCL is not Null, it then does include them. Has anyone any idea why?

[kfleming]

Even though your source is a null value, doing the todate conversion results in an empty date rather than a null date.______Kathleen__R&R Support

[Chris_Ransom_(Guest)]

Oh I see. Can you tell me then what is the correct syntax to check for an empty date field in a filter please?

[kfleming]

You would use__Date_cancel not equal to __and then just press Enter in the compared to box. This will give you a {} blank date value.____Kathleen__R&R Support