The below link can help you :
You can even use the combination of above function and concat as well.
And for prevent date, use dateadd function
Hi Can you please let me know how to get the expression done in ADF pipeline to get the date time format in '2021-11-01 06:00' format.
And also to get previous date with same format please.