dan_14

Does anyone know how to use a function inside of the $X() method? I need to convert a date when including in my where clause: $X{BETWEEN, CONVERT_TZ(FROM_UNIXTIME(a.date / 1000),'UTC',TimeZone),StartDate,EndDate} Note - TimeZone, StartDate, and EndDate are all parameters. I even setup UTC as a string parameter but still getting an error.

Does anyone know how to use a function inside of the $X() method? I need to convert a date when including in my where clause: $X{BETWEEN, CONVERT_TZ(FROM_UNIXTIME(a.date / 1000),'UTC',TimeZone),StartDate,EndDate} Note - TimeZone, StartDate, and EndDate are all parameters. I even setup UTC as a string parameter but still getting an error.

I have a scheduled report with StartDate and EndDate parameters, but once the report runs the first time it seems to cache those values and never updates on the next days it runs. I don't even set a value for the parameter, but default to new Date(System.currentTimeMillis()- 7*24*60*60*1000) and new Date(System.currentTimeMillis()- 1). Has anyone figured out a workaround for this. Very basic functionality you would think for running dynamic reports....