To calculate max date-1

[yogitamehta10]

HI All,

i have date in my data as date dd/mm/yyyy

i need to calculate sale where date is maximum date of  this date -1, in short i want the yeterday's day.

Thanks in advance

[sunny_talwar]

May be this:

Sum({<Date = {"$(=Date(Max(Date)-1, 'DD/MM/YYYY'))"}>} Sales)

Update: Missed -1 above

[sunny_talwar]

or for yesterday, you can use Today()

Sum({<Date = {"$(=Date(Today() - 1, 'DD/MM/YYYY'))"}>} Sales)