dateformat

arkiboys 9,621 Reputation points
2022-08-16T18:55:33.067+00:00

hello,
in adf copy activity source, I have this expression:

@markus.bohland@hotmail.de (
dataset().apiName,
dataset().filterBegin,
dataset().dateFieldName, ' gt ', addDays(utcNow(), int(dataset().daysBack)),
' and ', dataset().dateFieldName, ' lt ', utcNow(),
' ', dataset().filters
)

in pipeline I have a variable : v_CurrentDate, i.e.: 2022-08-15

I get an error when I change the above expression to below:
the message is:

"Message":"The query specified in the URI is not valid. The DateTimeOffset text '2022-07-16T00:00:00.0000000' should be in format 'yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)?' and each field value is within valid range.","ExceptionMessage":"The DateTimeOffset text '2022-07-16T00:00:00.0000000' should be in format 'yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)?' and each field value is within valid range.

@markus.bohland@hotmail.de (
dataset().apiName,
dataset().filterBegin,
dataset().dateFieldName, ' gt ', addDays(dataset().p_CurrentDate, int(dataset().daysBack)),
' and ', dataset().dateFieldName, ' lt ', dataset().p_CurrentDate,
' ', dataset().filters
)

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

1 answer

Sort by: Most helpful
  1. arkiboys 9,621 Reputation points
    2022-08-16T19:11:26.44+00:00

    solved by using formatDateTime
    Thank you