Share via

How to Set the Date for Tomorrow's Date in ADF

Mike Kiser 1,536 Reputation points
2021-04-26T16:03:13+00:00

Hello! @Nasreen Akter @MartinJaffer-MSFT @KranthiPakala-MSFT

I have 2 dates in my Web Activity. I know how to make today's date as
"@{pipeline().TriggerTime}"

But how can I set the date for tomorrow's date and the next day after tomorrow's date based on today's date. For Example: In other words I need to set the next days date and the date after the next days date.

"EffectiveStart": "2021-04-27T00:00:00",
"EffectiveEnd": "2021-04-28T23:59:00",

Thanks!
Mike Kiser

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,630 questions
Accepted answer
  1. Nasreen Akter 10,811 Reputation points Volunteer Moderator
    2021-04-26T19:45:12.697+00:00

    Hi @Mike Kiser ,

    You can try the following expression. Thanks!

    @markus.bohland@hotmail.de (formatDateTime(adddays(utcnow(), +1), 'yyyy-MM-dd'), 'T00:00:00')
    @markus.bohland@hotmail.de (formatDateTime(adddays(utcnow(), +2), 'yyyy-MM-dd'), 'T23:59:00')

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.