C claing Sep 9, 2005 #1 I'm trying to work out how to count the number of days between a star date and closing date Can this be done
I'm trying to work out how to count the number of days between a star date and closing date Can this be done
A Arvin Meyer [MVP] Sep 9, 2005 #3 A simple DateDiff () will count the difference: DateDiff("d",[FirstDate],[SecondDate]) If you want to calculate working days difference, you can try this function at the Access Web: http://www.mvps.org/access/datetime/date0006.htm -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
A simple DateDiff () will count the difference: DateDiff("d",[FirstDate],[SecondDate]) If you want to calculate working days difference, you can try this function at the Access Web: http://www.mvps.org/access/datetime/date0006.htm -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
