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

Mike Kiser 1,531 Reputation points
2021-06-23T17:19:44.777+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,468 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 37,661 Reputation points Microsoft Employee
    2021-06-24T15:14:31.08+00:00

    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')

    108997-adddays.gif

    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
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful