<div>
What time comes with it?<br />
<br />
You might try <br />
<br />
Date(currentdate())<br />
<br />
mlmcc
</div>


What time comes with it?

You might try

Date(currentdate())

mlmcc

<div>
what comes up on the BO report is 11/29/10 but when I export to Excel I get<br />
<br />
11/29/2010 &nbsp;10:43:05 AM<br />
<br />
What i need is just the date 11/29/2010 not the time after it &nbsp;in the cell<br />
<br />
I tried Date(currentdate()) and I get an error: Invalid identifier Date at position 1
</div>


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

<div>
Is this Crystal or one of the BO tools?<br />
<br />
Try CDate<br />
<br />
mlmcc
</div>


Is this Crystal or one of the BO tools?

Try CDate

mlmcc

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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?<br />
<br />
=CurrentDate()
</div>
</div>


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()

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

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.