?
Solved

Business Objects report - Export Current date but only date not time

Posted on 2010-11-29
4
Medium Priority
?
1,060 Views
Last Modified: 2013-11-15
I have this code in a report so when it is exported to Excel today's date is populated. I only want the date not date and time and with this I am getting both.

When you look on the report in BO you see just the short date as that is how I have it formated but when exported the time comes with it. How do I get just the date?

=CurrentDate()
0
Comment
Question by:Pdeters
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 34230629
What time comes with it?

You might try

Date(currentdate())

mlmcc
0
 

Author Comment

by:Pdeters
ID: 34230666
what comes up on the BO report is 11/29/10 but when I export to Excel I get

11/29/2010  10:43:05 AM

What i need is just the date 11/29/2010 not the time after it  in the cell

I tried Date(currentdate()) and I get an error: Invalid identifier Date at position 1
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 34231108
Is this Crystal or one of the BO tools?

Try CDate

mlmcc
0
 
LVL 35

Accepted Solution

by:
James0628 earned 2000 total points
ID: 34236719
 mlmcc,

 It looks like a BO format formula (as opposed to CR).  The old BO doesn't have the Date function to convert a datetime into a date.



 Pdeters,

 I haven't had to deal with this in a BO report, but it looks like BO is not using the format when it does the export and is just exporting the full value (I've actually had similar problems when exporting a CR report to Excel).

 Try using FormatDate to change the date into a string in the form that you want, rather than using the field format.  I think that will work.

=FormatDate (CurrentDate() , "mm/dd/yyyy")


 James
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question