Dear Gurus,

I know there are lot of postings on this subject. But can't seem to find the solution.
I have a report to run that require to filter out all the weekends (Saturday & Sunday) for the month.
Do I create a holiday file for the weekends or use SET BUSDAYS?

Regards,

Tan

This message has been edited. Last edited by: <Kathryn Henning>,

I would create a DEFINE to convert the database dates into a day format then apply a filter on DEFINE field where it is not equal to SAT or SUN

Hi Tan,

If you need this as a filter, then neither.

If this was a FOCUS data source, then I would be inclined to use DOWK function to obtain the day of week and then filter WHERE NOT field IN ('Sat','Sun') etc.

A word of warning, this type of define is unlikely to be translated to SQL at all so, if your source is SQL then maybe look at re-defining the existing date column as USAGE=W, ACTUAL=DATE instead of HDMYYs etc. in your synonym - although I doubt that this will translate well either

Always check the SQL trace to ensure that your extraction process is as efficient as possible.


T

Dear Atturhari & Tony,

Thank you for your advise. I will make the changes at database level.

Tan