Apologies for the inconvenience.
As I mentioned earlier, the "Z" at the end of the formatted date-time string in your Azure Data Factory expression indicates that the time is in UTC (Coordinated Universal Time). This is a standard format used to represent time zones in ISO 8601.
If you want to remove the Z from the end of the formatted date string, you can use the substring function to exclude the last character.
Calculate the formatted date string without the Z:
@substring(formatDateTime(addDays(utcnow(), -1), 'yyyy-MM-ddT00:00:00'), 0, 19)
Explanation:
formatDateTime(addDays(utcnow(), -1), 'yyyy-MM-ddT00:00:00')
: This part generates the date string with the Z at the end.
substring(<date-string>, 0, 19)
: This part extracts the first 19 characters of the date string, effectively removing the Z.
This will format the date-time string in the specified format, but without the "Z" at the end.
I hope this information helps.
Thank you.