Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Date range comparison Post Reply Post New Topic
Author Message
dibblejon
Newbie
Newbie


Joined: 05 Jan 2011
Location: United Kingdom
Online Status: Offline
Posts: 32
Quote dibblejon Replybullet Topic: Date range comparison
    Posted: 06 Oct 2011 at 11:45pm
Hi
 
Can someone help me with a formula to help me sub total my report this date range comparison?
 
Year 1 = 01/01/10 to 30/09/2010
Year 2 = 01/01/11 to 30/09/2011
 
Help would be fab!
 
Thanks
 
IP IP Logged
dibblejon
Newbie
Newbie


Joined: 05 Jan 2011
Location: United Kingdom
Online Status: Offline
Posts: 32
Quote dibblejon Replybullet Posted: 07 Oct 2011 at 12:44am
Managed to fix it myselfTongue
 
(if month ({slhist.DATE}) in 1 to 9

and year ({slhist.DATE}) = 2010 then totext ("Period 1")

else if month ({slhist.DATE}) in 1 to 9

and year ({slhist.DATE}) = 2011 then totext ("Period 2"))

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.014 seconds.