Date Filter

Hello all,

I am trying to set up a onedrive folder watch where a new file getting added to a folder triggers my scenario. I have had some issues with onedrive triggering with old files so am trying to set up a filter where the scenario only goes ahead if the file creation date matches the current date, but to no avail. I have even tried converting both dates into string as I would only like the scenario to continue if the file creation output contains todays date. Can anyone see what I am doing wrong?

Current Flow and filter

Onedrive Output

Date Output

One thing I did notice is that the date output string seems to appear empty in the filter for some reason

Any help would be greatly appreciated!


Hi @Joao_Marques1,

Be mindful that ‘current date’ or {{now}} has to exactly match if you use it as an unformatted date filter. And as there is always a lag of some sorts between systems, it is impossible to match the created date from OneDrive to the {{now}} date in Make.

The lag could be milliseconds, seconds, or if there is a lot of traffic and digestion even minutes. One thing you can do is try to filter on created date within the last minute:

The other thing is to be mindful of timezones. The created date from OneDrive could be formatted in a different timezone than your Make account. If you use the {{now}} function and you hover over the date notation, you will see the raw date value. This should be ending with a Z, for Zulu time (UTC+0).

Some external sources don’t pass dates in UTC+0, but in their current timezone. Altough with OneDrive, that does not seem be the case.

Please, follow these steps when asking a question, and you’ll be more likely to get a helpful answer:

:writing_hand: Give us a detailed explanation of what you’re trying to achieve

:footprints: Tell us about any steps you’ve tried so far

:camera_flash: Include screenshots of:

  • your scenario flow and setup (functions, mappings, variables, etc.)

  • module configurations and outputs

  • any error messages you are getting

:card_file_box: Share the blueprint of the scenario you are asking a question about. (this does not contain the connection or personal information)

Certified Make Expert and Partner
Book a consult with me

1 Like