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

Question

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

Answer 1

There is also

@pipeline().TriggerTime

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

Answer 2

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.