Based on a condition, add 30 days more in a column

(0) Share

Report

Posted on by JasonCastro

111

If these conditions are respected, I need to take the value of the [END_DATE] column and do the following calculation: ([END_DATE]+30 days - current date), and save this value in the column [TIME_EXPIRE]

I tried to use the add days function, but I couldn't do the math bringing the values of the column [END_DATE]

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Re: Based on a condition, add 30 days more in a column

Hi @JasonCastro

Do you want to get the time difference between the end date plus 30 days and the current date, this store this value to the column Time Expire?
Based on your description, I have made a simple test for your reference.
1. Here is the flow:
div(div(sub(ticks(addDays(items('Apply_to_each')?['EndDate'],30)),ticks(utcNow())), 10000000), 86400)

2. Result:

Best regards,
Sylvia