Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Date range in selection formula not working Post Reply Post New Topic
Author Message
Michele
Newbie
Newbie
Avatar

Joined: 21 Jun 2019
Location: United States
Online Status: Offline
Posts: 6
Quote Michele Replybullet Topic: Date range in selection formula not working
    Posted: 25 Nov 2019 at 3:24am
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!
Accept that which is good
IP IP Logged
Michele
Newbie
Newbie
Avatar

Joined: 21 Jun 2019
Location: United States
Online Status: Offline
Posts: 6
Quote Michele Replybullet Posted: 25 Nov 2019 at 3:33am
I changed the link order in database expert so the table with the dates is on the right instead of the left and it seems to have fixed it. It's an inner join =. I wouldn't expect that to affect it.
Accept that which is good
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.