In an ADF Web Activity Body, how can you set today's date - Please help

Question

question

ewinkiser asked Mar 23, '21 MartinJaffer-MSFT answered Mar 23, '21

In an ADF Web Activity Body, how can you set today's date - Please help

Hello again! @nasreen-akter @MartinJaffer-MSFT

Here is just one of the Web Activities Body:
{
"EmployeeNumber": "@{item().employeeId}",
"EffectiveStart": "2018-10-01T00:00:00",
"EmploymentStatus": {
"IsBenefitArrearsEnabled": false,
"XRefCode": "@{item().status}",
"ShortName": "",
"LongName": ""
},
}

I need to send in today's date (the date of the REST call) for EffectiveStart. Is there any variable I can use to do this; is there something I can put in the above body for EffectiveStart to be todays date/time in the same format?

Thanks again!
Mike Kiser

azure-data-factory

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-03-23T16:58:35.58Z

MartinJaffer-MSFT answered Mar 23, '21

There is also

@pipeline().TriggerTime

For the time the trigger is fired (not the scheduled time)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2021-03-23T03:11:07.897Z

NandanHegde-7720 answered Mar 23, '21 NandanHegde-7720 edited Mar 23, '21

Hey ,
You can use @formatDateTime(utcnow(), 'yyyy-MM-ddTHH:mm:ss') function to get the date. This would provide the time as per UTC.
There are other functions like @convertFromUtc() to get the date in needed timezone.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question