Help with removing first 3 days from a Max date Field

[JKFoil]

Hello

Can someone please help me.

I have Created a new field, Max Date. I have appended it to the rest of the columns.

I now  need to remove rows from a different field referencing the Max Date field  -3 days

Timestamp	Max_ timestamp
2021-03-04T23:59:59Z	2021-03-04T23:59:59Z
2021-03-04T09:32:34Z	2021-03-04T23:59:59Z
2021-03-03T23:59:59Z	2021-03-04T23:59:59Z
2021-03-01T23:59:59Z	2021-03-04T23:59:59Z
2021-02-24T23:59:59Z	2021-03-04T23:59:59Z
2021-02-21T23:59:59Z	2021-03-04T23:59:59Z

I would expect to see only the bottom 2 records. 

[jamielaird]

Hi @JKFoil ,

Here's a workflow which demonstrates how you can do this.

[neilgallen]

to suggest a different route, a filter with the following condition would also work:

[timestamp]>= datetimeadd([max_timestamp],-3,'days')

Provided that the data itself was in a datetime format that is recognized by alteryx. If not, then:

datetimeparse([timestamp],"%y-%m-%dT%H:%M:%SZ") >= 

datetimeadd(

datetimeparse([Max_ timestamp],"%y-%m-%dT%H:%M:%SZ"),

-3,'days')

[JKFoil]

Jamielaird

Worked perfect.  Thank you very much.