Answered

Need to subtract days from one date field with result in another.

(1) Share

Report

Posted on by Koreno

I have a SharePoint list with a few date fields. Only one of these is entered upon item creation. This field is titled [ProposalDueDate]. I have 2 other date fields that need to calculate a date off of [ProposalDueDate]. These fields are [EstimateDueDate] and [TakeOffDueDate]. In layman's terms... [EstimateDueDate] should calculate as [ProposalDueDate] minus 5 days [TakeOffDueDate] should calculate as [ProposalDueDate] minus 10 days I do not have much experience in SharePoint or Flow, but I have a little is VBA. I tried to do something that was logical to me in the Dynamic Content tab but that doesn't work. [ProposalDueDate]-5 I have searched google for days to find this solution but having no luck. Any help pointing me in the right direction would be great. Thanks,

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-bacao-msft on at

Like (2)

Report

Hi @Koreno,

You could get the corresponding date using the addDays() function in Expression.

Image reference:

EstimateDueDate: addDays(triggerBody()?['ProposalDueDate'],-5)

TakeOffDueDate: addDays(triggerBody()?['ProposalDueDate'],-10)

For more usage of expressions and WDL functions, please refer to the link below:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
Koreno 10 on at

Like (0)

Report

Thank you for the reply. I have been very busy lately with my primary duties (estimator) so I will try this solution when I can get back into this. When I do, I will let you know how is turned out. Thank you for the time.

Was this reply helpful? Yes No
Koreno 10 on at

Like (0)

Report

I decided to give it a try just now. It worked perfect. Thank you much.

I do however have another question. Instead of setting those 2 dates in a flow, could I make the field calculated so not only when an item is created, but also when the proposal due date is changed, the estimate and take off due dats just automatically update? Something like =ProposalDueDate-5 or =ProposalDueDate-10

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Koreno,

Yes, you could create Calculated column, based on ProposalDueDate.

In addition, this could also be achieved through Flow.

You could set When an item is created or modified as trigger, and you could achieve the effect you want.

If this answers your question, please mark the post as solved.

Best Regards,

Barry

Was this reply helpful? Yes No
Koreno 10 on at

Like (0)

Report

When I try to do this as a caculated field, I get errors and it wont let me. Could you give the the correct code to put in the box?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

Hi @Koreno,

You could select the corresponding column to perform the calculation.

Like:

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
WDRC 247 on at

Like (0)

Report

@v-bacao-msft

Any idea how I automate adding say 365 days to a date or 366 in a leap year. The issue in mind is that an insurance certifcate runs out at the end of the month. So during a process I always want to be able to add the correct amount of days for the different condtions. So thus the certicate expiry should allways be the end of the month not say a day early. It then needs to write the correct date to the SP list. I only ask this as 2020 will be such a year.

Regards,

Andrew

Was this reply helpful? Yes No