Hi All,i have to make weekwise report.For example every month 1 to 7 is first week ,8 to 15 is second week…and so on…
But my problem is 1(first day) comes on monday and some time on friday.it is easy to fix when it is monday but if 1(firstdays)comes on friday then only one days in first week.how to calculate this.along with 30 and 31 days.
Pls help…
i am using this fromula
SELECT ((Form = “assign”)) & reqdate<@adjust(reqdate;0;0;-21;0;0) then this is first week and so on
where reqdate is a date field.
Thanks.
Rajeev
