Add days to current date field - HELP!

[Tarjani]

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!

[Tarjani]

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.

[yashag2255 · Accepted solution]

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!

[Tarjani]

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!