Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Current date.. HELP! Post Reply Post New Topic
Author Message
superman22011
Newbie
Newbie
Avatar

Joined: 02 Feb 2012
Location: United States
Online Status: Offline
Posts: 9
Quote superman22011 Replybullet Topic: Current date.. HELP!
     Posted: 26 Apr 2012 at 4:13am
Hello guys,

I'm working on a report which i need lots of help, I've learned more of crystal reports but haven't be able to figure this one out.
PLEASE HELP!

i need a formula that display only when its base on effective date.

if (Current date) is greater than {Procedure_Fees.Current_Effective_Date} to display {Procedure_Fees.Current_Fee_Amount} all others {Procedure_Fees.Previous_Fee_Amount}

PLEASE HELP! i would truly appreciate it!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 26 Apr 2012 at 4:16am
if currentdate>{Procedure_Fees.Current_Effective_Date} then {Procedure_Fees.Current_Fee_Amount} else {Procedure_Fees.Previous_Fee_Amount}
IP IP Logged
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