dd/mm/yy as 20th of month following (?parameterdate)

[knorth1233]

We have customer statements that require the customer to pay as of the 20th day of the month that follows the statement print date. The statement print date is a (?parameter)

Any ideas on how the formula should look...?

(?parameter) "formulated as a month" + 20 days = dd/MM/YY (the desired result)

Any help would be appreciated.

Thx

 

[synapsevampire]

I'll assume that "formulated as a month" means that it is a parameter that has the month number, if not, please share the type of parameter and what it contains:

cdate(year(currentdate),{?parameter},22)

-k

 

[dgillz]

SV's formula wont work for December. Try this:

If {?Parameter} <> 12 then
Date(Year(CurrentDate),{?Parameter},20) else
Date(Year{CurrentDate)+1,{Parameter},20)

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com