Adding Dates

[ReyOrtiz]

Hi All

I working on a project, and I need to create a flow that will take the date on a column and add the requested time; for example, if the date is 8/3/22 and I need the Monday in 2 weeks from the date, this will reflect into a Calendar.

I appreciate the help.

[Rhiassuring · Accepted solution]

Hi there, 

You can use the addDays functionality. 

Create a Compose action. Click on Expression. Type in "addDays()". In the brackets, point to the Dynamic Content that holds your date (for example, an output from SharePoint). Then, type a comma, and the amount of days you want to add - ie, 14 for 2 weeks.

ie, addDays(FIELD,2)

EDIT: Sorry I just noticed the Monday part. Would it be the Monday following the 2 week mark? Or the closest Monday to the 2 week mark?

[ReyOrtiz]

That worked, and it made it easier to write an expression from scratch; I like that shortcut, thank you