I m working on Azure Data Factory, and i m looking to set one variable in my pipeline, that always represent the past day (yesterday). This is the solution that i found for the poor syntax integration via API with a CosmosDB that MS ADF has, so i cannot use CAST GETDATE -1 as i already used in other pipelines for SQL relational databases.
Already tried with all the possible solutions that i found on Microsoft Documentation:
Set the variable by the Activity "Set Variable", in order to pass through a parameter in my pipeline. Set the parameter with the formula directly
Formula: @addDays(utcnow(), -1)