Generate 20 Radom Dates from last 14 days

[devrajsinghshekhawat]

Hello all,

How can I generate 20 random dates from last 14 days of current date?

Any solution?

Thanks in advance.

[tom18]

Hi there,

There’s a few ways to do this here’s one solution for you:

Backend:

1. Go to your backend workflows and create a new api workflow

2. Call it like: generate_random_dates and set one parameter to key: counter and type: number
   

   

3. Download random number generator plugin and set the number to -1 → -14
   

4. Create a new thing in your DB for this example I created a data type data and created a field to be a list of dates. Here you want to add the following:
   Current date/time +days: Result step 1 random number generator
   

5. Make it recursive:
   Schedule the same API workflow and use the parameter + 1 to add to the count parameter then under only when choose “counter < 20” (It will run 20 times then stop)
   

After this then go to the frontend and do the following:

Frontend:

1. Set up a button on your page to generate the dates
2. Schedule the API workflow and set the count to 1
   
   

I then set a repeating group up for this example and this is what I got:

Hope that helps!

[devrajsinghshekhawat]

Look like it will work for me.

I will implement this logic and will let you know.

Thanks @tom18