InfoSol Help Desk

Sometimes it is necessary to dynamically enter the last day of the month for a report, but, what if the date needs to take into account that the point of reference is before the current date? (ex: on the 1st and second day of the month they expect TODAY-2D be used as the reference for [LASTDAYINMONTH].

I would like to see a macro-reference-modifier that sets the reference date of a date macro to take a macro-generated date into account.

ex:  [LASTDAYINMONTH,[TODAY-2D],MM/DD/YYYY] = 01/31/2025 (given current date is actually 2/2/25)

A workaround has been created to inject a FHSQ query into a WebI doc using Oracle:

SELECT
    TRUNC(LAST_DAY(SYSDATE-2))
FROM
    SYS.DUAL

Import the doc into InfoBurst, Burst it to an xls, imported to a FileList, and use the FileList as the date prompt response.

(Be sure to run the FHSQ WebI report Burst before the main Burst, of course)