cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Date time calculation based on a sharepoint date field

Hello,

 

i'm building a flow where it will check  a sharepoint list and get couple of data in order to schedule a meeting on outlook based on some criterias however i'm stuck on the following

 

Basically I have a date column and i need to calculate a start date-time & End date-time taking into account 2 working days (from Monday to Friday)

 

For example : if date = 29/03/2018

                       then start datetime = 02/04/2018 09:00

                       and end datetime = 02/04/2018 10:00

 

So that i can use both to schedule the event

 

Thank you

4 REPLIES 4
v-yuazh-msft
Community Support
Community Support

Hi @ Friendyhere,

 

Could you please share more details about your needs?

Could you please share more details about your sharepoint list?

Does your sharepoint list have a date column? 

Do you want to create a meeting on outlook when an item is created in the sharepoint list, and the meeting would be created after two working days of the value of the date column in the sharepoint list?

 

Please share more details so we could try to help you.

 

 

Regards,
Alice Zhang

Anonymous
Not applicable

Hello

Thak you for your reply

 

basically I just need the correct exression for adding 2Business days+9hours to a given date record because it's required for "Create event V2" start time / end time

 

I tried to use the Addhours() function but i can't seem to figure out how to make it work so that it would take into account only business days

 

You can use the addHours function to get a date/time that is 2 days plus 9 hours from a given date. 

 

To account for weekends, use the dayOfWeek() function in a switch statement.  Use dayOfWeek to evaluate your addHours function.  The dayOfWeek function will return 0 for Sunday and 6 for Saturday.  In your switch statement, add additional hours as required in your dayOfWeek() calculation (24 or 48 hours additional).  

 

Here is a lnk to a screenshot that shows the concept.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Anonymous
Not applicable

Dayofweek() got the job done, thanks a lot 🙂

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (12,252)