Auto-delete Page posts older than 10 days

[ANCA]

What I tried in a Filter (Map ON on both sides), comparing Created time + 10 days ≤ Now

formatDate(
  addDays( parseDate(1.Created time; "YYYY-MM-DDTHH:mm:ss.SSSZ"); 10 );
  "YYYYMMDDHHmmss";
  "Europe/Bucharest"
)
<=
formatDate( now; "YYYYMMDDHHmmss"; "Europe/Bucharest" )

I also tested the Unix version:

formatDate(addDays(parseDate(1.Created time; "YYYY-MM-DDTHH:mm:ss.SSSZ"); 10); "X")
<=
formatDate(now; "X")

Problem: No bundle passes the filter in the Inspector, even though many posts are older than 10 days.
Example of Created time: 2016-12-28T16:03:06.372Z.

Questions:

• Working expression: Does anyone have a filter that reliably passes items older than 10 days?

• Parsing tip: For the trailing Z, should I use "YYYY-MM-DDTHH:mm:ss.SSS[Z]" or a different pattern?

• Timezone: Is there any known issue comparing with Europe/Bucharest vs UTC?

• Operator choice: Would you keep it as string compare (YYYYMMDDHHmmss) or stick to Unix seconds ("X")?

Any snippet or mini-screenshot of a setup that works would be important. Thanks!

[Prem_Patel]

Hi @ANCA

You do not need to format data if date and time is in this format : “timestamp”: “2025-07-16T12:36:27.000Z” cause when you create add days formula on {{now}} it will be also in same format : “-10 days”: “2025-08-09T08:43:56.210Z” so normal filter will work.

You just need to create a filter like this

You only have to format or parse date when formats are different so you can match both of them.

Best,
@Prem_Patel

[ANCA]

Hello, @Prem_Patel

Thank you for your reply. What I’m doing wrong here?

I use {{1.created_time}} as is the the date of the post

LE: I changed to the earlier than and I get the same error.

[Prem_Patel]

The filter condition Operator that you are using is Numeric and Not Date Time, Click on the drop down and update it with Date and Time options

Best,
@Prem_Patel

[ANCA]

I get the same error with the earlier than setting.

[Prem_Patel]

can you share output of those dates and filter setup? You can also try formatting on both values, but make sure to have it in same format, no extra quotes or characters.