filter dataset for: date1 date2 by 90 days

Question

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?

binu_acs · Answer

@wonka1234 Similar approach to @Emmanuel_G and @JosephSerpis

Date_0927_1.yxmd

Emmanuel_G · Answer

@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. 🙂

Filter dataset.yxmd

JosephSerpis · Answer

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.