Crystal Reports Selection expert date older than 3 years

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Selection expert date older than 3 years

Post Reply

Post New Topic

Author	Message
Nigge Newbie Joined: 03 Feb 2013 Online Status: Offline Posts: 6	Topic: Selection expert date older than 3 years Posted: 03 Dec 2013 at 8:38pm
	Hi! I am doing a report where I need to find parts in our stock that has been received more than 3 years ago How do I do this? (this will be a monthly report so specifying a explicit date wont do it) I want something similar to: reveive_date > 3 years ago
	IP Logged


Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 03 Dec 2013 at 8:42pm
	Hi In record selection expert give below filer condition : Received_Date >= dateadd('yyyy',-3,currentdate) This will extract data more than 3 years anytime
	Thanks, Sastry
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 04 Dec 2013 at 4:52am
	just the odd question, wouldn't it be a date that is 'smaller' then the today less 3 years?
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 04 Dec 2013 at 6:12pm
	Yes, you are right it should be like : Received_Date <= dateadd('yyyy',-3,currentdate)
	Thanks, Sastry
	IP Logged

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