Hello all,

I read somewhere in here that we can setup a report to automatically run at certain date.

I would like to set my report to run on the first day of the month and also if somehow I can set the ADATE to pull the latest month (i.e. if current date 5/1/2018, then ADATE should be 2018/04/01).

I would appreciate any help. Thanks!

My InfoAssist version:
o WebFOCUS Business Intelligence
o Edition: WebFOCUS
o Product Release: 8.0
o Service Pack: 04
o Build Version: branch8004
o Build/GEN Number: 59
o Build/GEN Date: Mon Sep 02 13:55:30 CDT 2013
o Application Server: Apache Tomcat/7.0.33

This message has been edited. Last edited by: FP Mod Chuck,

Right Click the report and pick Schedule. That's where your journey will begin.

https://webfocusinfocenter.inf...rc/tech-library.html

Thank you for the schedule reference. Do you have any suggestion about setting the ADATE to pull the latest month. As of right now, my filter include ADATE = 2018/04/01 and I have to change the ADATE = 2018/05/01 for next month. Easy enough to do but thought there is a way to automate this also. If I do not filter with ADATE then my report would give me every month since history.

Do you have to code this in InfoAssist or can you use the Text Editor?

One way to do this is to use Date Functions like DATEADD and DATEMOV. First create a field that contains today's date. Then get last month by subtracting 1 from the month. Then get the Beginning of the Month using BOM.

DEFINE FILE WF_RETAIL
CURR_MONTH/YYMD=&YYMD;
LAST_MONTH/YYMD=DATEMOV(DATEADD( CURR_MONTH , 'M', -1), 'BOM');
END
  

https://webfocusinfocenter.inf...g/source/date127.htm

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