Date math again...

Butch Ammon butch at rich.srcoils.com
Wed Jan 4 11:07:08 PST 2006


Good afternoon,

I have another question regarding dates, calculations, and taking into account 
weekend dates.  Isn't there a simple way of doing this?

Example:

  If:
Then: dd = (10 - 9)
  If:
Then: Show "@This is the total number of days " < dd
  If:
Then: end

  Field 9 is the date when the order was entered (i.e.. 12/06/05)
 Field 10 is the date when the order was shipped (i.e.. 12/21/05)

Dummy field "dd" comes up saying 15 for the total number of days, which is 
correct.  **BUT** what about weekends?  It counted Dec 10th, 11th, and also Dec 
17th and 18th as work days!  Technically, dummy field "dd" should be: 11 days.

My main question:  Does anyone have a quick and easy method of doing date math 
and taking into consideration the weekends inbetween the two dates?

Thank you very much for your help!

Butch Ammon
Super Radiator Coils
Richmond, VA


More information about the Filepro-list mailing list