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