ADF How can I add one day to the following expression?

Question

Hi @Nasreen Akter @MartinJaffer-MSFT @KranthiPakala-MSFT

I have a date of let's say 9/13 that I am passing through in a Web Call:

    **"EffectiveStart": "@{item().terminationdate}",**  

How can I add one day so that the date shows as 9/14?

I just tried @{formatDateTime(adddays(item().terminationdate,+1), 'yyyy-MM-dd' )}
but that didn't work....any ideas? But now I'm seeing that termination date can be null also.

Thanks
Mike

Answer 1

Hi @Mike Kiser ,

Thank you for posting query in Microsoft Q&A Platform

Please check below detailed explanation to add one day.

I have two variables here "TerminationDate" & "TerminationDateNew". I have assigned value in "TerminationDate" as "2020-09-13".
Idea is to add one day to "TerminationDate" and store it in "TerminationDateNew" variable. To do the same I used below expression

@formatDateTime(adddays(variables('TerminationDate'),1),'yyyy-MM-dd')

Hope this will help. Thank you

----------------------------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a email-notifications.