How can I make the previous day's filter?

[burak]

How can I make the previous day’s filter?

The date column contains the number of days of the month. And if today is the 13th, I want to filter the 12th. I did this as in the image I posted in the filter activity, but it didn’t work.

[Anil_G (Anil Gorthi)]

@burak

activity

Hi @burak

Please try this

Now.Adddays(-1).ToString("%d")

Direct tostring only will give whole date not only the day you need …SO we need to specify it

cheers

[burak]

it worked. thanks

[s0biesky (Raul)]

Hi @burak , that function will output the whole date (day, month, year and hour) where you just need the day. So try using DateTime.Now.AddDays(-1).Day.ToString which outputs only the day