Datetime filtering

Please help. I created a scenario that sends SMS to customers who make reservations. I want a different sms to go out when a reservation is created and another when the reservation is updated. I figured that the simplest and most logical way would be to set up a router with a filter - one when the creation time equals the update time and another when the update time is later than the creation time. Despite setting such filters, even when the creation time is every minute the same as the update date, the router still leads to the path with the update.

As you can see in the gif below, all 3 dates are the same, but the filter thinks the condition is not met. For some reason, the filter thinks that the update date is later than the creation date and lets go through the second router path.
screen-capture-ezgif.com-cut

Why is this happening?

Can you show how you did setup the filter?

Welcome to the Make community!

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

Are you using the date time operator for your filter? Also what is the output from the calendar module?

Thanks for replies.

  1. Here is my Google calendar output:

  2. Here is filter setting for update sms

  3. Here is filter setting for new reservation:

  4. Here is my blueprint (I modified it slightly to censor the calendar email address ):
    blueprint.json (18.0 KB)

I would prefer not to publish packages of performed operations due to the amount of sensitive data. However, if it is necessary to help, I will do it later, but I need to clean the data.

You need to change the date/time into Unix Timestamp format for those operators to work. Just do this and it should work:
image

2 Likes

That worked! Thank you!

Why would the previous approach not work if both Created and Updated are strings formatted as proper datetime values?

Not sure tbh. Stumbled upon it since I work a lot with google calendar. It functions as a date/time when mapped into moduels but for some reasons when used for filters it needs to be formatted. :man_shrugging: