Non trading days calculation

  • Thread starter Thread starter David Reid via AccessMonster.com
  • Start date Start date
D

David Reid via AccessMonster.com

Is there any way to lookup/ count the days between 'startdate' and
'enddate' , work out how many of them are Sundays (non trading days), and
subtract those Sundays from the total days?

That would give me the final figure I am looking for,
- Total days traded/worked during the date range specified.
 
David said:
Is there any way to lookup/ count the days between 'startdate' and
'enddate' , work out how many of them are Sundays (non trading days),
and subtract those Sundays from the total days?

That would give me the final figure I am looking for,
- Total days traded/worked during the date range specified.
Click to expand...

Count how many Sunday are in taht period making
dcount("[Yourdate]";"YourTable", "Formt([Yourdate],"ddd") = 'sun')

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Back
Top