Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: date parameter Post Reply Post New Topic
Author Message
tatanka
Newbie
Newbie


Joined: 10 Feb 2010
Location: Greece
Online Status: Offline
Posts: 7
Quote tatanka Replybullet Topic: date parameter
     Posted: 24 May 2011 at 9:16am
Hi to all.
Can someone help me?
I would like to create a report to compare sales for a company. For example they  want to put  in creteria  a range of date(2011-02-03 /2011-03-03) and in two tables they would like to have the values from 2011 and  the exactly dates from previus year.
It would be like this:

date range from 2011-02-03 to 2011-03-03

                         (2011-02-03 to 2011-03-03) (2010-02-03 to 2010-03-03)
sales                         5.000                               6.000



IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 May 2011 at 2:53am
@previousYearEndDateForm
dateadd(yyyy, -1, {?EndDate})

@previousYearStartDateForm
dateadd(yyyy, -1, {?StartDate})
IP IP Logged
tatanka
Newbie
Newbie


Joined: 10 Feb 2010
Location: Greece
Online Status: Offline
Posts: 7
Quote tatanka Replybullet Posted: 25 May 2011 at 6:42am
Thanks a lot.It works!
IP 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