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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter Formula

Status
Not open for further replies.

Steve95

MIS
Nov 3, 2004
265
US
Hi All

Iam have setup a parameter as follows :
{@01 cdate} in {?Start Date} to {?End Date}

the information that will be returned from the above will be a select year information, but as we know a year has holidays. What I need is a formula which reads the parameter year and then picks up the holiday formula. I have the formula which works fine without a parameter.

I tried doing a 'if, not, then' but currently no joy....

Many Thanks in Advance

tc
Shin
 
lol......

as stated, I am need formula that points to the parameter, reads what date range it looking at and then goes to the holiday formula and excutes. This in return will return the datadiff from the start date to the end date minus the holiday(s).

Please advise if information insufficent

Many Thanks
Shin

 
Dear Shinda,

It might be nice if you posted what solved your issue so that when someone else needs the solution, it is here in tek-tips.

regars,

ro

Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top