Recent content by amyceres

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?