I am a newbie at WebFocus Info Assist.

I have a daily payment summary report. I have the filter set to the payment date = today's date (hard coded), the report is on a scheduler which runs at 11:45pm to capture payments made for the day.

How do I eliminate editing the today's date (hard coded) on a daily basis?
I would also like to capture payments made on weekends and holidays, but our office is closed and I am not able to capture the information, unless I manually change the today's date (hard coded) the next working day, then manually running the report.

Please assist, thank you.

Lou Palomo

This message has been edited. Last edited by: Tamra,

Hi Lou,

Look into system and statistical variables within the online documentation. Substitute your hard-coded date with &YYMD or whatever date format you're comparing against.

What's the format of PAYMENT_DATE? Under DATA tab DEFINE a new field called CURR_DATE and set it to &YYMD

Then use it to compare payment date with this field.

WHERE PAYMENT_DATE EQ CURR_DATE;

DEFINE FILE ORDERS
CURR_DATE/HYYMD=&YYMD ;
END

TABLE FILE ORDERS
BY CUSTOMERID
BY PAYMENT_DATE

WHERE PAYMENT_DATE EQ CURR_DATE;
ON TABLE PCHOLD FORMAT HTML
END

This message has been edited. Last edited by: BabakNYC,

You would benefit from the book 'Almost 1001 Ways to Work with Dates in WebFOCUS' Available from Aviter, Inc.