Hello @Bhaskar Konar, I happened to tweak the code a bit, and it worked as I desired. Thank you for your support on this matter. A special thanks from my senior as well. PFA code snippet below. CAST(SUBSTRING(CAST(TIMESTAMPADD(SQL_TSI_HOUR,8, "- General Information"."Invoice Entered Date") ASchar)FROM 1 FOR 10) AS DATE)…

Hi @Dimple-Nagesh-Support-Oracle, Thank you for your prompt response. We are currently working with the OTBI report. I have noted the information regarding the BI Publisher report and will surely refer to it if anything comes up related to BIP reports. Thanks & Regards, Vamsi S.

Hi @Bhaskar Konar, @Hassan El Bouihi-Oracle, Thank you for your prompt response. I tried the suggested option, and it successfully fetches only the date without the time after exporting it to the Excel using 'Formatted' option. However, the date is incorrect in all the cases. For instance, when an invoice is created…

Hello @Dimple-Nagesh-Support-Oracle, No worries, it’s all good! Noted on the steps shared and will make use of them when required. I do have another issue occurring in the same OTBI report and wanted to check if you’ve encountered something similar before. If so, your guidance would be greatly appreciated! Issue link:…

Hi @Bhaskar Konar @Nathan CCC, Thank you for your prompt responses. I have tried to define the 'Invoice Creation Date' column as a date using CAST; however, it is unfortunately not fetching the desired output. Therefore, I modified the column properties to retrieve only the date without the time component, and I am now…

Dear @Dimple-Nagesh-Support-Oracle, Thank you for your detailed Prompt response and guidance. I truly appreciate the effort you've put into explaining the steps. However, I’d like to let you know that I am not familiar with OSC and do not have access to it, so I’m unable to verify the configurations as outlined.…

Hi @Bhaskar Konar, Thank you for your prompt response. I tried the suggested option, and it successfully fetches only the date without the time. However, the date is incorrect in some cases. For instance, when an invoice is created on November 21st at 12:17 AM, it incorrectly shows the previous day as November 20th.…