<div>
<pre><code id="code-20-42809465-1">DateAdd(“s”, 908022961, “01/01/1990”) </code></pre>
</div>


DateAdd(“s”, 908022961, “01/01/1990”) 

<div>
Try this one<br />
<br />
Time(DateAdd('s', 908022961, Date(1900,01,01)))<br />
<br />
mlmcc
</div>


Try this one

Time(DateAdd('s', 908022961, Date(1900,01,01)))

mlmcc

<div>
Thanks for the input that will get me the time of day which is what I asked for. &nbsp;Much appreciated.<br />
<br />
But found out yesterday I need the mmddccyy also. &nbsp; <br />
&nbsp; &nbsp;Found out I will have to get the mmddccyy from that string also, &nbsp;is that doable also. &nbsp;<br />
<br />
Vendor defined the field as &quot;initial start time in seconds since 1/1/1990'<br />
<br />
Any help would be appreciated.
</div>


Thanks for the input that will get me the time of day which is what I asked for.  Much appreciated.

But found out yesterday I need the mmddccyy also.  
   Found out I will have to get the mmddccyy from that string also,  is that doable also.  

Vendor defined the field as "initial start time in seconds since 1/1/1990'

Any help would be appreciated.

tambrosi

<div>
thanks for all of the input. &nbsp; It is greatly appreciated.!!!!
</div>


thanks for all of the input.   It is greatly appreciated.!!!!

<div>
<div class="content wysiwyg-content">
Hope somebody can help with this one:<br />
I have a field that is defined as having all seconds, how can I get the Time of Day out of that field. <br />
field is 908022961 (seconds) <br />
&nbsp;to_date('19900101','yyyymm<wbr />dd') + &quot;starttime&quot;/86400 as startDate, &nbsp;(From SQL---but would like to use Crystal to get the Time of Day).<br />
it will convert to this date 2018-10-10 with the above statement. &nbsp;<br />
<br />
Date is 10/10/2018, &nbsp; but I need to find the time of day for this. &nbsp;<br />
Thanks<br />
Terry
</div>
</div>


Hope somebody can help with this one:
I have a field that is defined as having all seconds, how can I get the Time of Day out of that field. 
field is 908022961 (seconds) 
 to_date('19900101','yyyymmdd') + "starttime"/86400 as startDate,  (From SQL---but would like to use Crystal to get the Time of Day).
it will convert to this date 2018-10-10 with the above statement.  

Date is 10/10/2018,   but I need to find the time of day for this.  
Thanks
Terry

Get the Time of Day from a Field that is all seconds.

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.