6 Sep
2018
6 Sep
'18
8:38 p.m.
On 2018-09-05 17:54, Frank Cazabon wrote:
I use a calendar table (albeit in SQL server but that shouldn't matter). Then it's just a matter of some simple queries.
On 5 September 2018 16:47:27 GMT-04:00, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D
- (rose highlight) I've forgotten how to get Excel to close without
asking me this every time. Currently, I'm just calling the .Quit() method of my Excel object. I tried passing a .T. parm but that failed.
- (yellow highlight) Anybody know how to get this slick NETWORKDAYS
formula to work in VFP? Would be neat to have this and I thought perhaps someone already built it.
Frank -- it's a slick formula for determining the TIME that's passed within the workday hours set (not just days; that'd be simple).