Dynamic Date Filter

[Karl_Spratt]

Hi Community,

Need some help I'm trying to filter out ( I will use the false anchor of the filter) 

I'm trying to say ToDate([actual_shipment_date]) <= DateTimeToday()-730  

If the Shipment date more than the last 2 years dynamically show it as a true. 

that way in the false I will see any an unshipped lines, or any lines shipped in the last 2 years but I'm getting an error.

I think it's where I'm placing the 730 ( for 365 Days x 2) I've tried, wrapping in () in ' ' but neither is working can some pleae advise.

TIA,

Karl. 

[binu_acs · Accepted solution]

@Karl_Spratt 

TODATETIME([actual_shipment_date]) <= DateTimeAdd(DateTimeNow(),-730,'days')

[AkimasaKajitani]

Hi @Karl_Spratt 

In this case, You can also use DateTimeDiff function.

DateTimeDiff(ToDate([actual_shipment_date]),DateTimeToday(),'day')<=-730

To calculate the difference of days, you need to use DateTimeDiff function.

[Karl_Spratt]

Thanks All the solution I used was, but thanks all for your help here..

TODATETIME([actual_shipment_date]) <= DateTimeAdd(DateTimeNow(),-730,'days')