Downloaded business date formula not working

[seabubble]

Hi all,

I have downloaded this business date and time formula called cr9_business_days_samples.zip from here

http://support.businessobjects.com/communityCS/FilesAndUpdates/cr9_business_days_samples.zip.asp

I change the date fields to my ones and check the syntax. Its all OK. I then put the formula on my report and it caculates the days ok. I then put on the hours formula wich also check sytax OK, and it gives me 1:53 for the dates below.

create date/time close date actual SLA
01/10/2004 09:07:00 01/10/2004 10:39:00 2:32 1:53

Inside the hours formula you are ment to be able to change the business hours.

//Replace datetime(2001,12,23,11,50,0) with your starting //date
DatetimeVar FirstDateTime:= {@Create_Date};
//Replace datetime(2001,12,26,10,0,0) with your ending //date
DatetimeVar LastDateTime:= {@Revised closed time};
//Replace Time(09,00,00) with your business starting time
TimeVar BusinessStartTime:= Time(09,00,00);
//Replace Time(17,00,00) with your business ending time
TimeVar BusinessEndTime:= Time(17,00,00);

when I change 09,00,00 to 08,00,00 it makes no difference to the result! any idear's. Does the code from the above URL work for anyone else?

Cheers

 

[seabubble]

Wait on this one please ! !

 

[seabubble]

No it def does not work!
Help!