Changing notion database due date to current time

How To
1

Hello!

I’m trying to build a Notion automation that changes the due date for recurring tasks. For example, if the due date is August 2, 2024, and it is before the current time, it would be changed to the current date. If the date is after the current date, it would remain unchanged. I’ve tried some methods, but they don’t really work.

image
image2800×1576 396 KB

image
image978×1441 66.7 KB

How should I modify it?
Thank you in advance!

2

In the second screenshot, if that is the “Update database item” module and you want to set the date to the current time, you could use the {{now}} variable.

Otherwise, what is not working exactly?

3

Thanks for replying!

I’ve tried using the {{now}} variable, but it would change the due date of every single item in the database instead of only the ones that are outdated.

image
image2165×773 65.4 KB

This is the original date for the items
image
image2095×774 67 KB

And this is the one after I changed the variable to {{now}}.
Is it a problem with the search objects module?

4

Yes it might be - it sounds like the logic you want to follow is:

  1. Search objects (get all the incomplete database items with a due date on or before now)
  2. Update database item (set the due date to now)

It seems to me that these two modules would be enough to achieve your objective. I remain available if I am missing something or you encounter other issues

5

Thank you again!

image
image853×1415 51.8 KB

This is the search module I’m using because I want to only change the completed database items with a due date on or before now and without the ones with due dates after now.
However, once I set the aboved mentioned variable to now, all of my database items would be changed to the current date instead.
image
image857×1400 61 KB

When I first tested this module with the {{1. properties value: next due: string}} variable, it would show an error saying that the needed things for the parameter was missing(from what I remember).
How should I fix this?

6

Then, you can use the “next due” value, but since it’s a string, you need to ensure it’s parsed as a date. Either do this in Notion (change the formula to output a date), or in Make, using the parseDate() formula with this format as the second argument: YYYY-MM-DD

1 Like