How to make a trigger for mailing by date?

[alexkash]

I am making a process that should run at night, compare the date in the table with today's date and if they are equal (any other condition), do a mailing using HTTP Request.

Here is the difficulty: I have the date in the table in this format - 2024-02-15 00:00:00:00.000, without time. And the date for now is always with time.

How do I compare them for equality of dates, that this event was on the same day?

[mytharcher]

When you want to do any calculating or comparing between date values, you should always use date type with time. Or you should add the timezone diff by yourself before using them.

[alexkash]

How can I determine in the process whether this date-time value refers to a particular day (time does not matter, it is a whole day)?

[alexkash]

A simple example, process overnight applications that came in today. How can this be done in workflow?

[mytharcher]

Please make the example to be more specific, like what date and where users are at, and what date result are the users expecting?

[alexkash]

Hi! Thanks, that's what I've solved. But there is a question about the dates:
how do I calculate the date + 7 days in the workflow (I need to select people whose birthday is next week).