Filter on "now" minus 15 minutes (date manipulation)

jankoAgreena · April 25, 2024, 2:55pm

Hey there, I’d like to use a filter to stop a scenario if a timestamp is older than 15 minutes from the “now”.

I am getting the original timestamp from a Notion Database item.

I first format it to unix timestamp, choose greater or equal to and then format “now” to unix, subtract 15 minutes from “now” through addMinutes and then I subtract both values from each other. For some reason, this let the scenario continue even if it shouldn’t.

Have I missed something?

The timestamp from Notion is in the Copenhagen timezone (+02:00), could it be related to that?

This particular article help me craft what I have so far: Date Manipulation - #2 by Runcorn

Any pointers much appreciated!

samliew · April 25, 2024, 11:27pm

Welcome to the Make community!

If it’s already a date you don’t need to format it to Unix TS string variable just to compare it.

Instead of Numeric operator in the filter you can use a Date “Later than” operator to compare two date variables.

Then, at the bottom you can just do a

addMinutes(now; -15)

Formatting of date is usually only used when you want to display it to an end user who needs to look at the date in a particular format.

Links

Here are some useful links and guides to help you get started and learn more on how to use the Make platform, apps, and app modules —

General

Help Center | Tutorials
Make Academy – learn Make and get your certificate ← CHECK THIS OUT
Make Blog – get the latest updates
Features & Pricing

Help Center Basics

Mapping – What is mapping? What can I map? ← CHECK THIS OUT
Mapping with arrays – How to map items in an array ← CHECK THIS OUT
Tokens for parseDate | Tokens for formatDate
HTTP modules – Make a request, Get (download) a file
Webhooks – Error Handling, Responding to webhooks

Articles & Videos

Feature Requests & Suggestions

Partner & Custom Apps

samliew – request private consultation