Print Page | Close Window

DateRange in crystal report 2008

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=5008
Printed Date: 07 May 2024 at 9:03pm


Topic: DateRange in crystal report 2008
Posted By: TusharP
Subject: DateRange in crystal report 2008
Date Posted: 14 Dec 2008 at 11:03pm
I want you following record selection  formula in crystal report 2008.
It does not work, need suggestions?
 
{table.date}>={?From} and
{table.date}<={?To}


Replies:
Posted By: Savan
Date Posted: 14 Dec 2008 at 11:30pm

the syntax  for the formula is

table.date in date(year{?From},month{?From},day{?From}) to date(year{?To},month{?To},day{?To})
 
or
 
use the select option from the report menu and select the date field and then select is between option to give the date ranges
 


-------------
Thanks
Savan


Print Page | Close Window