Get the last saturday

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I'm looking for a function that will always return last saturday's date, for
example, today 6/30/2003 would the functin return 6/28/2003, and so on, till
7/5/2003, and from 7/6/2003 and ahead it should return 7/5/2003.


Thanks

Scott
 
Scott,

Date() - DatePart("w", Date(), vbSunday)

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia
 
Back
Top