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

Like (0) Share

Report

Posted on 17 Apr 2023 23:11:18 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 18 Apr 2023 at 03:25:50

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