I have a IF expression like IF(condition a AND condition b AND condition c AND condition d AND condition e, reportId,'N/A').
In condition I am comparing a variable with a column like
condition a 😆 createDate >= CalenderDate(column from one of my table)
condition b 😆 createDate <= CalenderDate(column from one of my table)
What I observed that rows having createDate is NULL in database but satisfying the condition c,d,e are displaying in my result. My assumption for logical expression is NULL >= CalenderDate will return FALSE and therefore the whole expression will return FALSE adn finally the IF expression should display 'N/A'.
It should operate internally like
IF(FALSE AND TRUE AND TRUE AND TRUE AND TRUE,reportId,'N/A') => If(FASLE,reportId,'N/A') => N/A
