If date is greater than the other..

[Emma1]

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

[dplr-rn · Accepted solution]

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

[sunny_talwar · Accepted solution]

You can give this a shot as well

Date(RangeMax(Oppty.Date, Contact.Date)) as LAST_ACTION_DATE

[Emma1]

What of the case where both are null? How do we include it in the code?