BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Date Time horror


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
rpinxt
Senior Member
Senior Member



Joined: 23 Jan 2019

Posts: 76



PostPosted: Tue Oct 08, 2019 9:05 am 
Post subject: Date Time horror

So my report has a time field.
However when we bring it to excel it will show in the cell as :
1-1-1970 10:20:04

In webi you will not see 1-1-1970...

How can I make it that the field in the report only shows (exports) the time and not the (wrong) date??
Back to top
charlie
Forum Associate
Forum Associate



Joined: 20 Aug 2002

Posts: 902
Location: Woodinville, WA USA


flag
PostPosted: Tue Oct 08, 2019 11:01 am 
Post subject: Re: Date Time horror

How is the time field formatted in WebI? I can format a datetime field as time, export it to Excel and see the correct times, with no dates.
_________________
Regards,

Chaz
Back to top
rpinxt
Senior Member
Senior Member



Joined: 23 Jan 2019

Posts: 76



PostPosted: Wed Oct 09, 2019 2:08 am 
Post subject: Re: Date Time horror

Well the dimension is formatted as a 'Date Time'.
And in the report it is formatted as a Time.
It is set to '8:45 PM'.

I now noticed that when you format it as 'Default' is will give 1-1-70.
So somehow this default date is comming in from the Universe?

I only need the time part. But formatting in the report is only masking it.
Exporting to excel will always give you date & time and not only the time.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0283 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0248)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo