A Allen Browne Oct 26, 2006 #1 See: Doing WorkDay Math in VBA at: http://www.mvps.org/access/datetime/date0012.htm
F Faio Eric Oct 27, 2006 #2 I have a query based on a arrivaldate field and I wish to create a query to find the number of days to current date. By this what I did in a query is "dayscovered: =now()-[arrivaldate] I did got the answer correct except too many decimals which is not a problem. What I need is something like that except that it wont count weekends too. Any suggestion? Appreciate any help
I have a query based on a arrivaldate field and I wish to create a query to find the number of days to current date. By this what I did in a query is "dayscovered: =now()-[arrivaldate] I did got the answer correct except too many decimals which is not a problem. What I need is something like that except that it wont count weekends too. Any suggestion? Appreciate any help
