Create random date + time in the future

Hi all,
Can someone please help me with this one? I need a way to create a random date with time included let’s say within the next 7 days…what would be the best way of achieving this?

I know how to create random seconds delay, but days + specific time is quite difficult…

Expected results should be in the format of:
03/28/2024 10:20 PM
03/30/2024 1:44 AM
03/30/2024 6:28 AM
03/30/2024 9:41 PM

There are 7 * 24 * 60 * 60 seconds in seven days.

All you need to do is add a random number of seconds, using the built-in function addSeconds

e.g.:

{{addSeconds(now; random * 604800)}}

Screenshot_2024-03-30_220308

For more information, see https://www.make.com/en/help/functions/date---time-functions#addseconds--date--number-

4 Likes

@samliew, thank you, but what I’m trying to achieve is something similar to this, but including 7 days + hours
image

This date goes into the data store where this checks and sends emails based on the date:
image

1 Like