decker587
asked on
Add formula for fixed due date to crystal report using system date
Currently I have to edit a crystal report we use for customer statements every month to change the due date. i.e. December 2013 invoices will be due 01/10/2014. Is there a formula to use the system date to generate the due date?
Statements are printed the first of each month and are due by the 10th of the same month.
Also, if you "reprinted" the statement for that month on a day past the 10th, the due date would still be the 10th.
Statements are printed the first of each month and are due by the 10th of the same month.
Also, if you "reprinted" the statement for that month on a day past the 10th, the due date would still be the 10th.
Do you ever have to print a statement for a previous month say the November statement in December?
mlmcc
mlmcc
ASKER
@mlmcc, yes there is the 1% where we have to print a previous month.
@vasto, That does work, but you're right it would work better if it calculated the value off the running application. Is there a way to use the statement date parameter (@statementdate) to calculate the due date?
@vasto, That does work, but you're right it would work better if it calculated the value off the running application. Is there a way to use the statement date parameter (@statementdate) to calculate the due date?
Assuming it is a date then just put it in place of CurrentDate in vasto's formula
DateValue(Year({@statement date}),Mon th({@state mentdate}) ,10)
mlmcc
DateValue(Year({@statement
mlmcc
ASKER
There is an error in the statement, see attached.
Crystal-Error.JPG
Crystal-Error.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That works. Thank you, vasto.
DateValue(Year(CurrentDate
However , a better approach will be to create a parameter and provide the value from the calling application - you might need to print the reports for the next month.