Help with removing first 3 days from a Max date Field

Question

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

TimestampMax_ timestamp2021-03-04T23:59:59Z2021-03-04T23:59:59Z2021-03-04T09:32:34Z2021-03-04T23:59:59Z2021-03-03T23:59:59Z2021-03-04T23:59:59Z2021-03-01T23:59:59Z2021-03-04T23:59:59Z2021-02-24T23:59:59Z2021-03-04T23:59:59Z2021-02-21T23:59:59Z2021-03-04T23:59:59Z

I would expect to see only the bottom 2 records.

JKFoil · Answer

Jamielaird

Worked perfect.  Thank you very much.

neilgallen · Answer

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')

jamielaird · Answer

Hi @JKFoil ,

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

DT_Diff.yxmd