I'm trying to use crystal reports to filter only dates that are within the last 2 years. For some reason, it's still showing older dates in the results preview.
This is my selection formula:
{WorkList.StartDate} >= (Currentdate() - 730)
This is showing dates from current back through 2008. Any ideas why it's not showing 2016 to today? It seems to do the same thing with or without the () after Currentdate. Most examples I found are for subtracting 30-60 days from the currentdate, so I'm not sure if I can't subtract that many days?
Any help would be appreciated.
Thanks!
