filter dataset for: date1 > date2 by 90 days

[wonka1234]

Hi,

I have two date fields..

MAX_DATE and Action_Date. 

I want to identify records in my dataset where MAX DATE is greater then action date by 90 days.

I was planning on a doing a formula then filtering for this.

allowance =  If [MAX_DATE] > [c_Action_Date] then "90 day allowance" else '' endif

then a filter tool to filter for "90 day allowance" field.

Can anyone help with the 90 day part?

[JosephSerpis]

Hi @wonka1234 I would use the formula Datetimediff formula between your two dates then you can see if your max date is greater by 90 days. Have a read of this formula on the this help document.

[Emmanuel_G]

@wonka1234 

Find in attachement the way of doing this.

The key point is the using of DateTimediff function.

Let me know if ir works as you want and please, do not hesitate to mark this answer as solution if it helped. 🙂

[binuacs]

@wonka1234 Similar approach to @Emmanuel_G and @JosephSerpis