[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1066
  • Last Modified:

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

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
Pdeters
Asked:
Pdeters
  • 2
1 Solution
 
mlmccCommented:
What time comes with it?

You might try

Date(currentdate())

mlmcc
0
 
PdetersAuthor Commented:
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
 
mlmccCommented:
Is this Crystal or one of the BO tools?

Try CDate

mlmcc
0
 
James0628Commented:
 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now