Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone please help me with this issue in script.
(floor( IF(ISNULL(FIFTH_DOC_SENT_DATETIME),IF(ISNULL(FOURTH_DOC_SENT_DATETIME),
IF(ISNULL(THIRD_DOC_SENT_DATETIME),IF(ISNULL(SECOND_DOC_SENT_DATETIME),
FIRST_DOC_SENT_DATETIME,SECOND_DOC_SENT_DATETIME))))),'MM/DD/YYYY') as [Last Doc Sent Date]
This code works fine until THIRD_DOC_SENT_DATETIME, FOURTH_DOC_SENT_DATETIME, FIFTH_DOC_SENT_DATETIME are null.
But if there is data for THIRD_DOC_SENT_DATETIME or FOURTH_DOC_SENT_DATETIME or FIFTH_DOC_SENT_DATETIME. How should I give the condition in if clause. "If" takes only two parameters right.
Thanks in advance,
Regards,
Aditya
regarding syntax I think this is correct
date(floor(
IF(ISNULL(FIFTH_DOC_SENT_DATETIME),
IF(ISNULL(FOURTH_DOC_SENT_DATETIME),
IF(ISNULL(THIRD_DOC_SENT_DATETIME),
IF(ISNULL(SECOND_DOC_SENT_DATETIME),
FIRST_DOC_SENT_DATETIME,
SECOND_DOC_SENT_DATETIME))))),'MM/DD/YYYY') as [Last Doc Sent Date]
but is better if you explain your requirement; do you want the first not null date? maybe
date(
floor(
alt(FIFTH_DOC_SENT_DATETIME, FOURTH_DOC_SENT_DATETIME, ...........),
)
'MM/DD/YYYY') as [Last Doc Sent Date]
May also be worth a look at what the alt function does?