<div>
maybe <br />
<br />
DDMMYYYYhh:mmTT<br />
<br />
or maybe use two functions and concatenate them<br />
one with <br />
DDMMYYYY<br />
the other with<br />
hh:mmTT<br />
<br />
Regards
</div>


<div>
Certain letters in the format string are case sensitive. &nbsp;Capital M's are for months and lowercase m's are for minutes. &nbsp;Capital H's mean 24 hour clock while lower case h's mean 12 hour clock. &nbsp;You will need a mlmcc's formula with some minor changes:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41373775-1"><span>CStr(CurrentDateTime,&quot;ddMMyyyyhh:mmtt&quot;)</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I am presently trying to create a datetime formula that will populate at the time when the report is printed. The format for this will be 2109201502:15PM . So basically DDMMYYYYHH:MMTT. I have been beating my head off a wall because if I get the date and time combined I can't get it to leave the space out after the minutes where its formating it as DDMMYYYYHH:MM TT. Anything I bring into the formula wants to add a space where I don't want the space.
</div>
</div>


I am presently trying to create a datetime formula that will populate at the time when the report is printed. The format for this will be 2109201502:15PM . So basically DDMMYYYYHH:MMTT. I have been beating my head off a wall because if I get the date and time combined I can't get it to leave the space out after the minutes where its formating it as DDMMYYYYHH:MM TT. Anything I bring into the formula wants to add a space where I don't want the space.

DateTime Formula

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.