can we add hours in advance to the date time in the parameters in BI publisher report?
Hi,
created datetime parameter for the report. based on my server time it is populating date with time in the parameter. But i have to add one hour advance to the current server time in the parameter.
for example:
my server date with time 12/18/2019 02:15:32 PM
but i need to display in the parameter as : 12/18/2019 03:15:32 PM
in data model: parameter section default value given to {$SYSDATE()$} and date format string given as MM/dd/yyyy hh:mm:ss a
Regards,
RN