null or blank check for a date column in Table transformer code

Nags Subramanian

Hi , i have a table transformer code written like below.  The highlighted code check if the date is blanks does not work.  could you please let me know how exactly to check for this please? It always executes the else statement and returns T1.'End date'

5th column in the below table is T1.'End date'.

Last column is the 'Story max date' that i am trying to return.

thanks

Nagarajan.

 

case when T1.'End date' ="" then "Nov 30, 2025"


when (((select max(T2.'End date') from T2 where T2.'Epic Link'=T1.'Epic Name' and T2.'End date'!="" and upper(T2.'Status') in ("NEW","IN ANALYSIS","IN PROGRESS","IN REVIEW","READY","BLOCKED") group by T2.'Epic Link' ) !=NULL)
and ((select max(T2.'End date') from T2 where T2.'Epic Link'=T1.'Epic Name' and T2.'End date'!="" and upper(T2.'Status') in ("NEW","IN ANALYSIS","IN PROGRESS","IN REVIEW","READY","BLOCKED") group by T2.'Epic Link' ) !="") )
then (select max(T2.'End date') from T2 where T2.'Epic Link'=T1.'Epic Name' and T2.'End date'!="" and upper(T2.'Status') in ("NEW","IN ANALYSIS","IN PROGRESS","IN REVIEW","READY","BLOCKED") group by T2.'Epic Link' )
else T1.'End date'
end as 'Story max date'

 

SNo

Division

Epic

Epic name

Epic end date

Epic status

Story max date

94	X-Divisional	X-Divisional P&C & SB Data Analytics ICTO-24278 Financial Messaging and Sanction Filtering Data Mart	ICTO-24278	Nov 30, 2025	IN PROGRESS	Nov 30, 2025
46	NCL	NCL Securities Settlements (APAC) ICTO-12571 POETS-CLEARANCE	ICTO-12571	Dec 31, 2025	IN ANALYSIS	Dec 31, 2025
15	GWM	GWM Bahamas ICTO-28181 Treasury Suite	ICTO-28181		TO DO
84	X-Divisional	X-Divisional GCS ICTO-391 ELAR - ELARBAS CH	ICTO-391		TO DO
85	X-Divisional	X-Divisional GCS ICTO-4269 Regulatory Compliant Records Repository - RCR Americas	ICTO-4269		TO DO

Shawn Doyle - ReleaseTEAM

Instead of using != use IS NOT NULL.  You are also switching between "" and NULL, should be able to just use NULL.

From:

https://www.w3schools.com/sql/sql_null_values.asp

https://docs.stiltsoft.com/tfac/cloud/general-syntax-and-sql-functions-available-42246251.html#GeneralsyntaxandSQLfunctionsavailable-GeneralSQLsyntax

It is not possible to test for NULL values with comparison operators, such as =, <, or <>.

We will have to use the IS NULL and IS NOT NULL operators instead.