Hi, all the dynamic values are in UTC (documentation).
Maybe you can use the code like the one presented below + pass the variables between tasks (see Share information between tasks in a Databricks job) ?
%python
from datetime import datetime, timedelta
# Get the current date
current_date = datetime.now()
# Subtract one day to get the previous day or make any other shift
previous_day = current_date - timedelta(days=1)
# Format the date as a string in the desired format if needed
previous_day_str = previous_day.strftime('%Y-%m-%d')
# Now you can use previous_day_str as a dynamic variable in your notebook logic