CASE Statement using DATES

Question

Hi all,

I'm trying to filter on the following logic: if Date Sent is null, then 0, if Date Sent is not null, then Start Date minus Date Sent

Here's the syntax I'm currently using:

CASE   WHEN "Agreement Sent Date"."Date" IS NULL

THEN '0'

ELSE TIMESTAMPDIFF(SQL_TSI_MONTH, "Agreement Start Date"."Date", "Agreement Sent Date"."Date")

END

I get the following error when I run the report, and really can't make out what it's trying to tell me:

Datatype(INTEGER) nullable(1) unicode(1) external char(0) conversion to datatype(VARCHAR) nullable(1) unicode(0) external char(0) is not supported

Anyone mind explaining what I'm doing wrong?

Thank you in advance!

SriniVEERAVALLI · Answer

CASE   WHEN "Agreement Sent Date"."Date" IS NULL

THEN 0

ELSE TIMESTAMPDIFF(SQL_TSI_MONTH, "Agreement Start Date"."Date", "Agreement Sent Date"."Date")

END

OR

CASE   WHEN "Agreement Sent Date"."Date" IS NOT NULL

THEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Agreement Start Date"."Date", "Agreement Sent Date"."Date")

ELSE 0

END

3025352 · Answer

Do I need to cast anything?