Search results for query: *

I reason I want to do this is because I want to know the number of days between {lt_master.lock-exp-dt} and the current date.

I am trying to exclude the Sundays and holidays. I think this is correct but I am not really sure. Local DateVar Start := {lt_master.lock-exp-dt}; Local DateVar End := currentdate; Local NumberVar Weeks; Local NumberVar Days; Local Numbervar Hol; DateVar Array Holidays:=[ Date (2013,1,1)...

This is my excel formula =IF(D6="","",IF(D6="Purchase",TEXT(WORKDAY(E6,1,Holidays),"DDDD"),IF(D6="Refinance",TEXT(WORKDAY(A6,4,Holidays),"DDDD")))) I trying to find out how I would convert this into crystal report.

whoohoo they both work perfectly...thanks for the help

I am not using VBA but I am using Crystal Reports.

Yes I want to know how to convert the date to a general number...

4/22/13 + 60 would be 6/21/13 but I wanted it in general format or number format

thank you for the information...I found that I probably going to include the holiday in the @weekend formula because I am not getting the result that I want from keeping everything separate.

I want to convert ({currentdate}+ 60)to a number format.. so it would be 4/22/13 +60 = 41446..I been searching through the forum and I haven't gotten a clear answer. So say use a datevalue() or a dateserial() but either of them work.

I placed the formula in the Record Selection like you said to and it works!!!Thanks! but the @Holiday formula was suppose to be inserted into the Report Header in the Design View? I don't think that would work because it shows nothing.

Thanks Pete for the help..I am assuming it should look like this.??? WhilePrintingRecords; Local DateVar Start := {lt_master.application-dt}; Local DateVar End := currentdate; Local NumberVar Weeks; Local NumberVar Days; Local Numbervar Hol; DateVar Array Holidays; {lt_master.application-dt}...

It's a in house software database program that we used called Unifi.

All the information I pulled is from CVS file.

Please give me information? or examples?

Question would you be taking holidays into consideration?

? Anybody?

Yes, there would be data for weekends and public holidays that would need to be ignored and I would only need data for Monday- Fridays unless there is a holiday any of those days. Short of listing all 104 dates for the weekends to ignored what is an easier way? Thank you

When a report is upload into in Business Object and it is run and it has a subreport in the report footer would the subreport also refresh at the same time?

I have most of the stuff solved for this problem however, now that I don't count the weekend, when Friday roll around the weekend days are included in the report now. and I only want the weekday reports excluding the Holiday. Today I pulled up the reports for currentday. 4/5/13 I only want...

I know that this formula been touch on over and over again but I need help and solving this glitch in my formula There is three parts to this problem This is what I have currently.. For the @ Holidays I have this formula below however, when I check the formula for errors it keep saying that...