<div>
ps. for each field I add, I get 2 options... &nbsp;1 string and 1 memo... <br />
<br />
thanks,<br />
Broad.
</div>


ps. for each field I add, I get 2 options...  1 string and 1 memo...

thanks,
Broad.

<div>
Hi bdreed,<br />
<br />
Looking at using NotesSQL but it's install is throwing an error message so Lotus will get back to me on this.<br />
<br />
In the mean time trying your workaround ( converting back to date via formula ).<br />
<br />
Created a formula field with the following formula:<br />
<br />
DateTime({View__crLeads.Le<wbr />InHome1Dat<wbr />e})<br />
<br />
But upon save says there an error and then &quot;The field name is not known&quot; , but I selected it from the heirachy above the formula code box (ie the programme completed the formula, not me..?? &nbsp;Any pointers? &nbsp;What am I missing here!<br />
<br />
Thanks,<br />
Broad.
</div>


Hi bdreed,

Looking at using NotesSQL but it's install is throwing an error message so Lotus will get back to me on this.

In the mean time trying your workaround ( converting back to date via formula ).

Created a formula field with the following formula:

DateTime({View__crLeads.LeInHome1Date})

But upon save says there an error and then "The field name is not known" , but I selected it from the heirachy above the formula code box (ie the programme completed the formula, not me..??  Any pointers?  What am I missing here!

Thanks,
Broad.

<div>
ahhh. &nbsp;I needed the &lt;String&gt; on the end ;)<br />
<br />
All good now thank you!
</div>


ahhh.  I needed the <String> on the end ;)

All good now thank you!

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have setup a connection to Lotus Domino and have added some fields from my table into a Crystal 11 but they are appearing as string. &nbsp;How do I have them appear as Date/Time?<br />
<br />
In Lotus Domino the fields are stipulated as Date/Time..<br />
<br />
Please point me in the right direction.. &nbsp;I read under File &nbsp;| Options or Report Options there is a switch to get around this but assume this may be before V11?<br />
<br />
Much appreciated<br />
<br />
Broad.
</div>
</div>


Hello,

I have setup a connection to Lotus Domino and have added some fields from my table into a Crystal 11 but they are appearing as string.  How do I have them appear as Date/Time?

In Lotus Domino the fields are stipulated as Date/Time..

Please point me in the right direction..  I read under File  | Options or Report Options there is a switch to get around this but assume this may be before V11?

Much appreciated

Broad.

Why are my fields not showing as type Date/Time?

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.