Use a function in the Synapse data flow to specify a day-old folder.

Question

I want to use a function in Synapse data flow to specify a folder that is one day old, but I don't know how to set up the function.
This is the function I am using now.

   concat('delta/year=',toString(currentDate('UTC'),'yyyy'),'/month=',toString(currentDate('UTC'),'MM'),'/day=',toString(currentDate('UTC'),'dd'))  

Do I use "addDays"?
Any answers would be appreciated.

Answer 1

Hello @Kakehi Shunya (筧 隼弥)

Yes you can use the below expression.

toString (addDays(current date('utc'),-1),'dd')

This will give output as 29.