Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Another date problem, im rubbish at dates :( Post Reply Post New Topic
Author Message
robert
Newbie
Newbie
Avatar

Joined: 18 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 15
Quote robert Replybullet Topic: Another date problem, im rubbish at dates :(
    Posted: 30 Nov 2009 at 2:52am
ok so i have this report and what the report does doesnt really matter, but the data it needs to show must be only of the current year, so in the select criteria i chose table.date_created  greater than or equal to 01/01/2009 which is fine for this year, but come 01/01/2010 i need it to display just that yaers data but dont really want to change the select cirteria at the begining of each year. so i need some sort of formula using table.date_created but what????????
 
help please :)
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 30 Nov 2009 at 6:42am
Well, assuming you are running the report for records whose created date is not greater than the current date at the time running the report (future dates aren't available in the record set) then maybe table.date_created in YearToDate.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 30 Nov 2009 at 6:42am
if year({table.field}) = year(currentDate) then ...
 
 
 
does this help?
IP IP Logged
robert
Newbie
Newbie
Avatar

Joined: 18 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 15
Quote robert Replybullet Posted: 30 Nov 2009 at 8:41am
thanks guys i will give both these a try and see what happens, will let you know tomorow.
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.016 seconds.