How to filter a date field in Table

[VVJ]

Hi All,

I've created a Table chart which contain a field as 'Order Date'. In the expression editor I want to give a condition to load the data only if the Order Date is greater than (today()-30). 

Thanks in advance!

Regards,

VVJ 

[VVJ · Accepted solution]

adding,

I've used below condition and it seems to work.

=if([ORD Creation Date]>=(today()-30),[ORD Creation Date])