The following function will return date of any day of the week for specified date. It assumes that Sunday is the first day of the week.
Function DOWdate
Lparams dInDate, nDow
Return IIF(BETWEEN(nDOW,1,7), dInDate + (nDow - DOW(dInDate)), {})
? DOWdate( DATE(), 1)
? DOWdate( DATE(), 2)
? DOWdate( DATE(), 7)
>Hi All,
>
>I’m working on a payroll overtime program and struggling with the following. End user is suppose to give a date range and overtime is calculated accordingly. Our work week starts on Monday.
>
>My question is ,
> If user gives the starting date (MyDate) any thing other than MONDAY, how to find Monday’s date from MyDate ???
>
>Please Help !!!
>
>TIA
>
>- Jeana -
--sb--