Calculate Past Due Dates 1

[yatesk]

How can I calculate a past due date?

Example:

If a book was checked out from the library on
October 1, 2006 and it was due on October 16, 2006
How can Crystal calculate the past due date which will be on October 17, 2006?

I hope this makes since.

 

[lbass]

{table.checkedoutdate}+16

Or if you want to select records that overdue, you could use a record selection formula like:

{table.checkedoutdate} < currentdate-16

-LB

 

[yatesk]

Thank you so much. That really helped!...I have one more question concerning this issue...how can I retrieve 'how many days past due'?

 

[lbass]

Create a formula:

datediff("d",{table.checkedoutdate}+16, currentdate)

-LB

 

[yatesk]

Thank you.