Print Page | Close Window

Compaire two dates in one Table

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10532
Printed Date: 26 May 2024 at 3:51pm


Topic: Compaire two dates in one Table
Posted By: tarunjain
Subject: Compaire two dates in one Table
Date Posted: 14 Jul 2010 at 9:39am
Hi All,
 
I am using crystal report XI R2.
 
I am using one table and in that table there are two columns Past Due Date and Due Date.
 
Sometimes the date of both fields are same and sometime the date of both fields are different and I have to show both the date in different different col. into my RPT file. But there are two conditions :--
 
  1. If both date fields are same then I have to show only Due Date field and supress the Past Due Date.
  2. If both date fields are not same then I have to show both date fields into my crystal report.

How it's possible...Can anybody help me in this?

 
Thanks


Replies:
Posted By: DBlank
Date Posted: 14 Jul 2010 at 9:41am
right click on the pastdue field and select format field
select common tab
select suppress formula
table.duedate=table.pastduedate


Print Page | Close Window