Last Execution date and time in IST format

[rushikesh97]

Hi all,

I am running the report in web intelligence and want to display the last execution date and time of the report in IST format can someone please help me on this ?

I used LastExecutionDate() and LastExecutionTime() these functions but it gives me in GMT format

for example- 11/20/2023 07:25:00 AM GMT

But I need to display it in IST format

[amitrathi239]

You can use below formula to show time in IST.

=RelativeDate(RelativeDate(LastExecutionDate();30;MinutePeriod);5;HourPeriod)

[rushikesh97]

Thanks Amit.