S
Steve
Can I use some type of formula to age day by business days not calendar days?
And also exclude the NYSE holidays out?
And also exclude the NYSE holidays out?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
Yes, you can use the Format([YourDateField],"w") to eliminate weekend days.
Without more information (your table structure) I can not show you how to
apply it.
Without more information (your table structure) I can not show you how to
apply it.
S
Steve
This formula gives me the number of week not business days.
KARL DEWEY said:Yes, you can use the Format([YourDateField],"w") to eliminate weekend days.
Without more information (your table structure) I can not show you how to
apply it.
--
KARL DEWEY
Build a little - Test a little
Steve said:Can I use some type of formula to age day by business days not calendar days?
And also exclude the NYSE holidays out?
K
KARL DEWEY
I thought that was what I said. I also said I needed more information on
your data to tell you how to apply it.
--
KARL DEWEY
Build a little - Test a little
your data to tell you how to apply it.
--
KARL DEWEY
Build a little - Test a little
Steve said:This formula gives me the number of week not business days.
KARL DEWEY said:Yes, you can use the Format([YourDateField],"w") to eliminate weekend days.
Without more information (your table structure) I can not show you how to
apply it.
--
KARL DEWEY
Build a little - Test a little
Steve said:Can I use some type of formula to age day by business days not calendar days?
And also exclude the NYSE holidays out?
D
Douglas J. Steele
Check out http://www.mvps.org/access/datetime/date0012.htm at "The Access
Web", or my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access" (plus the related article in June, 2005). You
can download the columns (and sample databases) from
http://www.accessmvp.com/DJSteele/SmartAccess.html You will have to provide
the list of NYSE holidays, but hopefully the June, 2005 column will show you
how.
Web", or my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access" (plus the related article in June, 2005). You
can download the columns (and sample databases) from
http://www.accessmvp.com/DJSteele/SmartAccess.html You will have to provide
the list of NYSE holidays, but hopefully the June, 2005 column will show you
how.