Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have written this script to create one column with most recent update
If(Oppty.Date >= Contact.Date, [Oppty.Date], [Contact.Date])
as LAST_ACTION_DATE
Now some values of [Oppty.Date] and [Contact.Date] are null.
I want to introduce another line of code to take the field with a date if the other is null. Please help
not 100% sure on your requirements but taking a guess trying something like below
if(IsNull(Oppty.Date),Contact.Date,
if(IsNull(Contact.Date),Oppty.Date,
If(Oppty.Date >= Contact.Date, [Oppty.Date], [Contact.Date]) // if both not null
))
as LAST_ACTION_DATE
You can give this a shot as well
Date(RangeMax(Oppty.Date, Contact.Date)) as LAST_ACTION_DATE
not 100% sure on your requirements but taking a guess trying something like below
if(IsNull(Oppty.Date),Contact.Date,
if(IsNull(Contact.Date),Oppty.Date,
If(Oppty.Date >= Contact.Date, [Oppty.Date], [Contact.Date]) // if both not null
))
as LAST_ACTION_DATE
You can give this a shot as well
Date(RangeMax(Oppty.Date, Contact.Date)) as LAST_ACTION_DATE
What of the case where both are null? How do we include it in the code?