NEED AGING FORMULA THAT DOES NOT COUNT THE WEEKENDS

[Nmartin95]

How can I get an aging formula which does not take into consideration the weekend? So it would be how ever long a work order was open not counting the weekends into the age. The formula would give it to me the age in days.
Any help would be greatly appreciated thanks. I am using crystal reports 7.01.

 

[rosemaryl]

Dear NMartin95,

I am not at my computer with Crystal right now, but I believe the correct formula is:

DateDiff ("d", datefield1, ddatefield2) -
DateDiff ("ww", ddatefield1, ddatefield2, crSaturday) -
DateDiff ("ww", ddatefield1, ddatefield2, crSunday)

Hope that does it for you. Go to Help in Crystal and type in DateDiff to read all the options.

ro

------
Oh, I just noticed that you are on 7.

Check out the FAQ and try Ken Hamady's Business Days and Hours Formula - it's long, but it works like a charm!

There is a ufl that provides datediff functionality for 7.0 (5 - 7). I haven't used it but is should be the same. While you are there, you might as well get the DateAdd ufl!

Datediff:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/ufldtdif.exe.asp

DateAdd:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/UFLDateAdd.exe.asp

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.