Crystal Reports Select results by date

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Select results by date

Post Reply

Post New Topic

Author	Message
shaddy Newbie Joined: 20 Jul 2010 Online Status: Offline Posts: 7	Topic: Select results by date Posted: 20 Jul 2010 at 3:30am
	Hello All, I have created a report that generates a listing of orders based upon authorization type. Here is my problem, I want to get only orders that are five days old or older. What's the best way of doing this? System date - date column? Any help would be great.
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Jul 2010 at 4:00am
	in the select expert you can use a date add from currentdate table.datefield<=dateadd('d',-5,currentdate) Edited by DBlank - 20 Jul 2010 at 4:00am
	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