Beginning / End of week

[Pickering, John (NORBORD)]

Platform shouldn't matter. Here's a snippet which will give you Monday and
Friday based on the current date. You'll need to figure out for yourself
which Monday to Friday you want if you execute this on a weekend.

> define d-sunday date &
>   = date(days(sysdate) - mod(days(sysdate),7))
> define d-monday date = date(days(d-sunday) + 1)
> define d-friday date = date(days(d-sunday) + 5)
> report all
> go


04/11/09  Norbord Industries Inc.   PAGE   1

  D-SUNDAY  D-MONDAY  D-FRIDAY

  04/11/07  04/11/08  04/11/12

Regards,
JWP


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Viet Nguyen
Sent: 09 November 2004 20:37
To: Robert Edis; PH List
Subject: Beginning / End of week

Hi all,
   Please tell me if there are functions to return the date of Monday
and Friday of the current week in Quiz? I need to autorun reports from
Including data from Monday-Friday weekly.

I am in IBM AIX

Thanks.
Viet.