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]
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
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2