Get the last saturday

[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

 

[Graham R Seach]

Scott,

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

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

 

[Graham R Seach]

Scott,

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

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

 

[Scott]

Thanks, works good.

Scott

Scott,

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

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

 

[Scott]

Thanks, works good.

Scott

Scott,

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

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia