how to filter yesterday working data

[Anbumani]

I have Date Colum with format YYYYMMDD eg(20240603) I want to filter yesterday's data if we running the workflow on Monday then i need Friday's data and i want the filtered data in format DD/MM/YYYY

Please help with the code which i need to use

[Qiu]

@Anbumani 
I think we can think as below

If we run the workflow on Monday, then we need to go back to Monday by Minus 3 days from current day.

If we run the workflow on Sunday, then we need to go back to Monday by Minus 2 days from current day.

for rest weekdays, we can just go back to previous day by Minus 1 day from current day.

[Anbumani]

Thank you so much this solution works perfectly