Hi,
We've got a generic report built in studio that just lists a certain type of spend, and we've been asked to schedule it. Not normally a problem as you can just enter 'month-1' in the date parameter within the schedule screen or in the report, however we had to use Studio for this one due to a duplicate line issue (related to GRN lines etc).
I've got all the generic filters available, so equals, before, after, between, on or after etc but I can't use Month-1 when entering details for the parameter like I can with Adhoc.
I'm assuming this is an easy amendment to the expression? It currently looks like this, as we have it running from 01/08/23 -to date which is too much data:
new java.sql.Timestamp(new java.util.GregorianCalendar(2023,8,1,0,0,0).getTimeInMillis())
I've played around with the expression editor but my attempts so far just cause a crash when run.