Query with DATETIME Columns

Query with DATETIME Columns

Hello,

We have a query that returns multiple DATE/DATETIME columns from our ServiceDesk MSSQL database. We have set the "replace empty value as" in the settings to return "Not Assigned", but it doesn't return that value for our DATE/DATETIME columns with empty values. Instead the values are just blank...

Are empty values only replaced when the column is a string data type like VARCHAR/NVARCHAR or am I just missing something?

Please let me know if you need more information. Thank you!

                  New to ADSelfService Plus?