solved by using formatDateTime
Thank you
dateformat
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
)
1 answer
Sort by: Most helpful
-
arkiboys 9,686 Reputation points
2022-08-16T19:11:26.44+00:00