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,639 questions
{count} votes

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 No comments

0 additional answers

Sort by: Most helpful

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.