You are viewing limited content. For full access, please sign in.

Question

Question

Cloud Workflow: Calculate dates between 2 dates

asked on November 2, 2022

Hello,

I have a Form where I have Start & End date.

I want a Token to be created for dates beginning from Start till End to have all dates as a separate value.

 

The idea is to put these dates as separate record in Database.

 

Can someone Please help?

 

Regards,

S

0 0

Answer

SELECTED ANSWER
replied on November 2, 2022

This is actually simpler

 

0 0

Replies

replied on November 2, 2022

I don't have the time to write it right now, but...

initialize a date token with the start date

create a repeat loop testing that the date token is less than the end date

in the loop

    store the date token in a multi-value date token

    use date token calculator to add a day to the date token

    save the calculated date in the old date token

end loop

Use the values in the multi-value date token to create your database records via a for each value loop

0 0
replied on November 2, 2022

So:

Step1: Assign Token Value: Create Start Date

Step2: Repeat: Condition: Start is less than End

Step3: Inside Repeat, Assign Token & store in Multi Value token

Step4: I am not sure about this

 

Is my understanding correct?

If possible when you get time, can you please try to create & post screenshot or wf here?

 

Many Thanks!

0 0
replied on November 2, 2022

It'll be late in the evening your time... Later :)

0 0
replied on November 2, 2022

That's fine, thanks!

0 0
SELECTED ANSWER
replied on November 2, 2022

This is actually simpler

 

0 0
replied on November 3, 2022

Thanks

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.