Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Diff Between due date and Inv Date Post Reply Post New Topic
Author Message
HEMREDDY
Newbie
Newbie


Joined: 31 Jul 2013
Online Status: Offline
Posts: 38
Quote HEMREDDY Replybullet Topic: Diff Between due date and Inv Date
     Posted: 05 Feb 2014 at 9:09am
Hi,
 
I have the folloiwng data in a table.
 
Invoice Date  12/25/2013
Invoice Amount 2000.00
 
I would like to be able to enter a Due date as a parameter and would like get the number of days between the due date and the invoice date.
 
Say i would like to enter the due date as 01/10/2014, i would like to know how to enter that under slection expert.
 
Then after i enter the due date i want to calculate the number of days between the invoice date and the Due date which in this case would be 16.
 
Could anyone help me with this.
 
Thanking you,
Hem Reddy
 
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Feb 2014 at 10:11am
Unless you want to limit the data you would not use the "Due Date" parameter in the select statement.
 
Create a parameter called 'Due Date' (or whatever) as a date type
create a formula field to use as your calculation for the total days
datediff('d',invoicedate,?due date)
IP IP Logged
HEMREDDY
Newbie
Newbie


Joined: 31 Jul 2013
Online Status: Offline
Posts: 38
Quote HEMREDDY Replybullet Posted: 05 Feb 2014 at 10:18am
Hi,
 
I did that and i am getting a message that a date is required here
 
reddy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Feb 2014 at 10:29am

what is it highlighting?

What is the actual formula you used?
 
IP IP Logged
HEMREDDY
Newbie
Newbie


Joined: 31 Jul 2013
Online Status: Offline
Posts: 38
Quote HEMREDDY Replybullet Posted: 05 Feb 2014 at 12:26pm
hi,
 
I got it straight. I names the Parameter as Due Date and that was creating the problem. Once i changed this everything worked fine.
 
Reddy
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