Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

knorth1233

IS-IT--Management
Joined
Sep 23, 2002
Messages
3
Location
CA
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top