Solved

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

Posted on 2010-11-29
4
1,032 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
  • 2
4 Comments
 
LVL 100

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 100

Expert Comment

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

Try CDate

mlmcc
0
 
LVL 34

Accepted Solution

by:
James0628 earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
crystal report check box and wingdings font 7 168
how to combine a date and time field in a query 9 48
Crystal report highlighting 5 28
Crystal reports filter out records 2 20
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

914 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now