I am facing a date pattern issue in my reports. The requirement is to show date as DD-MMM-YYYY:HH:mm:ss in 24 hours format. Now whenever my date is 31-DEC-YYYY and time is 00:00:00, report studio adds 1 in the year.
Ex - my date in table is 31-DEC-9999:00:00:00, report studio displays it as 31-DEC-10000:00:00:00
as i went online, i learn it is a known problem. But does anyone has any solution for same?
Any help will be appreciated. TIA
Have you tried use an if or a case statement to change the value of the date, for explample adding 1 second, in that case?