2

I am using Web Intelligence for reporting however, the SQL script i use runs fine within Oracle where it displays the date and time of a column.

But when i run this report through web intelligence and then export, it only displays the date.

I am probably missing something incredibly easy but I cant see it.

Suncatcher
  • 10,355
  • 10
  • 52
  • 90
ConfusedJJ
  • 15
  • 2
  • Just to add to this, when the Excel file is exported, it looks like the time format is there but the cell format is incorrect. Is there another way to amend the cell format before its sent? – ConfusedJJ Jan 12 '22 at 14:53
  • Please provide enough code so others can better understand or reproduce the problem. – Community Jan 23 '22 at 08:28

1 Answers1

1

All you should have to do is explicitly set a format rather than leaving it as the default format.

enter image description here

And I get this...

enter image description here

Isaac
  • 3,240
  • 2
  • 24
  • 31
  • Thanks Isaac. Really appreciated. that worked great! Is there any way to remove the AM / PM format and just have 24 HOUR time? – ConfusedJJ Jan 17 '22 at 13:02
  • Sure. You just need to create a Custom Format. All the options can be found [here](https://help.sap.com/viewer/819e1e8fbbdf48a9a6129b44216e15ab/4.2/en-US/4721c57e6e041014910aba7db0e91070.html). – Isaac Jan 18 '22 at 17:51
  • If this answer is correct, kindly mark it as so. Thanks! – Isaac Apr 15 '22 at 14:00
  • Hi Isaac. It does, thank you! Apologies for the late delay in responding. Not sure how to mark it as answered though, sorry. – ConfusedJJ Apr 18 '22 at 15:53
  • I guess the correct terminology is "Accepted". https://stackoverflow.com/tour – Isaac Apr 18 '22 at 16:40