Print Page | Close Window

Formula for year in current date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7910
Printed Date: 04 May 2024 at 2:45pm


Topic: Formula for year in current date
Posted By: snufse
Subject: Formula for year in current date
Date Posted: 05 Oct 2009 at 5:11am
I have a date field that I need to compare to year in current date. Not sure how to set up the formual. Thank you
 
{SALESTKT.TICKET_DATE} > CurrentDate


Replies:
Posted By: Memoli28
Date Posted: 05 Oct 2009 at 5:21am
 
Hi,
 
create new formula with following:
 
year({SALESTKT.TICKET_DATE} )=year (CurrentDate )
 
some kind of boolean.
 
hope this will help.
 

Posted By: snufse
Date Posted: 05 Oct 2009 at 7:48am
That worked, thank you.

Posted By: Vertex
Date Posted: 04 Nov 2009 at 7:57pm
how numbervar date can change into the datevar ....give me solution my code is here ...

numbervar yr:=2004;
numbervar monthselect:=12;
numbervar firstday:=1;
datevar createdate:= cDate (yr, monthselect, firstday);
createdate; 

-------------
Hi Peoples

Posted By: Vertex
Date Posted: 06 Nov 2009 at 7:26am
plz plz plz ...give solution .... how numbervar date can change into the datevar ....give me solution my code is here ...

numbervar yr:=2004;
numbervar monthselect:=12;
numbervar firstday:=1;
datevar createdate:= cDate (yr, monthselect, firstday);
createdate; 

-------------
Hi Peoples


Print Page | Close Window