Add days to current date field - HELP!

(0) Share

Report

Posted on by Tarjani

243

Hi all,

When creating an action to Update a field using Common Data Service (Current Environment), I am trying to add 365 days to a date that is in an existing field. The problem is that when the flow runs, it adds 365 days to the field from today's date, and not the date in the field.

Example - date in field says : 03/03/2020, it should add 365 to that date, not the date it was modified.

The expressions I am using are shown below to assist in clarifying.

addDays(outputs('Get_Subscription_record_on_Invoice')?['body/ec_currentperiodstart'], 365)

addDays(outputs('Get_Subscription_record_on_Invoice')?['body/vin_enddate'],365)

The above expressions seem to be doing what I would expect from - addDays(utcNow(), 365) - instead of adding on the date that is in the field.

Any light would be greatly appreciated!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Tarjani 243 on at

Like (0)

Report
Copy link

Link copied!

An extra note to add:

If I am to add 365 days in the below scenario it works fine:

Field a: 03/03/2020
Field b: This field wants to have a date that is 365 days ahead of field a.

In this scenario the expression I have noted above works fine. The issue is if I want to add 365 days to the same field - in the scenario that would be adding 365 day to field a, so that it becomes 03/03/2021.

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Tarjani

Can you check if there is data already present in the field in which you want to perform the add days action? You might want to add a compose action and check the run history of the flow to check what date is being returned.

Based on the above, you can add an action to get the record and try again.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Tarjani 243 on at

Like (0)

Report
Copy link

Link copied!

Hi @yashag2255 ,

I had been looking into the outputs for the flow, but your response made me go check the audit history as well - which showed me my issue.

The expression was updating the field correctly, but there was an update happening in the background changing the date to today's date. This was unexpected!

Thanks for your feedback, I might not have seen the back ground change otherwise!

Was this reply helpful? Yes No