Problem With Date Function

[munna1317]

Hi Everyone,

I have a date field . I want an expression for date greater than 30 days.

Date format(dd/mm/yyyy)

Date>30 days.

how it can be done , plz help me and sort out me with this problem,

Thxs in Advance ,

harish

[MK_QSL · Accepted solution]

SUM({<Date = {'>$(=Date(Max(Date)-30))'}>}Sales)

or

SUM({<Date = {'>$(=Date(Today()-30))'}>}Sales)

[munna1317]

thxs manish