[Datamart-News] Dates from OBIEE Change when Exported to Excel

[Datamart Support * DAS]

Good afternoon,

I wanted to let you know of an issue that arose today. First, my tech support completed a potential fix to help resolve the long outstanding OBIEE export to Excel issues. The result did fix our main issues (Dollar figure and general field formats); however, it provided a new issue. We now have a date problem. The export is adjusting the date back by one day in Excel. I have asked tech support to roll back the changes and re-review.

Here is an example of what was in OBIEE:
[cid:image003.png at 01D96645.64864D00]

And what populates in Excel when the data is exported:
[cid:image004.png at 01D96645.64864D00]


Thanks for your patience.
Aaron Wallace
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230403/a4fbbbc3/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 18648 bytes
Desc: image003.png
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230403/a4fbbbc3/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 36339 bytes
Desc: image004.png
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20230403/a4fbbbc3/attachment-0001.png>