Hi!
There is a DOW() function. If you have a date inside of the week, add 1 to it until DOW() returns 5( or 6 or whatever you need).
HTH.
>Hi,
> How to get the date of the end of a particular week?
>
>Thank you
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.