VERSAGO

All

Most records in SAP Business One that have a time associated with them store the time in a field separate from the corresponding date.  Some SQL manipulation is needed to convert the database value to a “time” value that can be used in Versago.   The manipulation is shown in the Resolution section below.

<p>In this example, the Create Date and Create Time of a Service Call are stored in two separate columns: CreateDate and CreateTime.&nbsp; To convert the CreateTime column value to a SQL 'time“ value, use the following statement:</p><p>select<br />cast(dateadd(minute,cast(right(t0.createtime,2) as int),(dateadd(hour,(t0.createtime/100),t0.CreateDate))) as Time) as [CreateTime]<br />from OSCL t0</p><p>You can also use this same statement with “as DateTime” instead of “as Time” to get a full date &amp; time string.</p>

HowTo

08 Aug 2018