Getting yesterdays date

I often use this handy command to select all zip files with today's date

Select *.zip date={date|YYYY/MM/dd} DESELECTNOMATCH

I've been trying to find a way to do the same thing but for yesterday's date. Is it possible? Thanks.

1 Like

Yes.

Select *.zip date={=DatePart(Now()-1d, "yyyy-MM-dd")=} DESELECTNOMATCH
2 Likes

Perfect. Many thanks.