Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Crystal Date Comparison Post Reply Post New Topic
Author Message
ReportNewbie
Newbie
Newbie


Joined: 09 Nov 2009
Online Status: Offline
Posts: 1
Quote ReportNewbie Replybullet Topic: Crystal Date Comparison
    Posted: 09 Nov 2009 at 6:56am
New to Crystal Reports.
I have a date opened field and  a date closed field.
I need to select those records that have a closed date<= 30 days of the created date.
 
I have tried everything I know of and then some.
 
I am sure it is a very simple calc. and there are functions that are available.
 
Any help at this point will be HUGELY appreciated.
IP IP Logged
AdamField
Groupie
Groupie


Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
Quote AdamField Replybullet Posted: 09 Nov 2009 at 7:00am
Hey Mr Reportnewbie
 
you can do normal calculations on dates like
currentdate - 30 for example
 
in your case i would sudjest somthing like
 
IF closed date <= create date - 30 THEN ....
 
Hope it helps
 
Adam
IP IP Logged
NewJack
Newbie
Newbie


Joined: 24 Nov 2009
Location: United States
Online Status: Offline
Posts: 6
Quote NewJack Replybullet Posted: 01 Dec 2009 at 7:11am
Adam,
 
quick question...  I am trying to do the following and I keep getting a year mjust be between 1 and 9999 error.
 
 
if  (invoice date) In AGED0to30Days then invoice amt
 
 
my inovice date is an int data type and formated as 20091202.  any ideas on how I can get this to work.  I know I will probaly need to convert the inovice date field, but I am drawing a blank on how.
 
Thanks for your help.
IP IP Logged
NewJack
Newbie
Newbie


Joined: 24 Nov 2009
Location: United States
Online Status: Offline
Posts: 6
Quote NewJack Replybullet Posted: 15 Dec 2009 at 6:56am
Nevermind.  I figured it out.  Thanks though.
IP IP Logged
imsascha
Newbie
Newbie


Joined: 10 Apr 2011
Online Status: Offline
Posts: 1
Quote imsascha Replybullet Posted: 10 Apr 2011 at 4:07pm
thx AdamField,

this tips and trick just solve my problem. love crystal report
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.