AnsweredAssumed Answered

Help! Im getting a "Date format picture ends before converting entire

Question asked by marlon.mckenzie on Aug 13, 2010
Latest reply on Aug 18, 2010 by Chris_Hackett
When I run the following script through a process:

<sql:query var="min">
select min(start_date) As min_date
from [Table1]
where parent_id = '${gel_objectInstanceId}'
</sql:query>
<core:set value="${min.rows[0].min_date}" var="v_min_date"/>

I get a date variabe that is fomatted like this: '2010-08-14 00:00:00.0'. I think the extra zero is causing the above error and am looking for a way to truncate the value so it could them be used to update a field without error. Any ideas?

Thanks,
Marlon

Outcomes