Filtering with Dates

[kayla_o]

Hi all, I'm trying to come up with a solution where I can filter on any dates that are within 90 days or less than other date.  Ideally, I want to have an output similar to the 3rd column. 

Example:

Date 1	Date 2	Within 90 days
2022-04-01	2023-01-01	0
2022-05-01	2022-07-01	1
2022-05-01	2023-04-01	0
2023-01-01	2023-07-01	0
2023-06-01	2023-07-01	1

[ShankerV · Accepted solution]

Hi @kayla_o 

Please use the below formula in the Formula too.

IF DateTimeDiff([Date 2 ],[Date 1 ],"days")>90
THEN 0
ELSE 1
ENDIF

Many thanks

Shanker V

[kayla_o]

thanks!