Topic
3 replies Latest Post - ‏2014-02-06T08:01:08Z by ExInEx
JuanRomero
JuanRomero
14 Posts
ACCEPTED ANSWER

Pinned topic using datetime atributes at a workflow

‏2014-02-04T21:54:57Z |

 

Hi everybody
 
We are creating a workflow that at some point will compare the ticket's "creation date" atribute versus the ticket's "start date" atribute.  We want to compare the dates or the days not the datetime atribute itself.
 
We are having some issues at the conditional node:
 
 When we add the following code to the expresion, we are getting SQL -245  error  (-245 THE INVOCATION OF FUNCTION routine-name IS AMBIGUOUS):
 
date(:reportdate) <> date(:actualstart)
 
We changed the code as below.  This way allowed  us to have the expresion without errors and to activating the process. However at the moment of applying the process on a record we are getting  some errors.
 
date(to_date(:reportdate)) <> date(to_date(:actualstart))
 
 
what should we do in order to compare datetime attributes at a conditional node ?
 
We really appreciate any help you can give us
 
Best regards
 
Juan Romero
Updated on 2014-02-05T12:59:26Z at 2014-02-05T12:59:26Z by JuanRomero
  • ExInEx
    ExInEx
    60 Posts
    ACCEPTED ANSWER

    Re: using datetime atributes at a workflow

    ‏2014-02-05T04:01:43Z  in response to JuanRomero

    Hi,

    I've create a new workflow which is referring to SR object and tested the expression below was returned as successful.

    :ticket.reportdate <> :ticket.actualstart

    Tested environment:-
    OS: Windows 2008 R2
    DB: DB2 9.7
    WAS: WebSphere 7.0.0.17

    • JuanRomero
      JuanRomero
      14 Posts
      ACCEPTED ANSWER

      Re: using datetime atributes at a workflow

      ‏2014-02-05T12:54:35Z  in response to ExInEx

      Hello DEOCK YONG SHIN

      The expression ":ticket.reportdate <> :ticket.actualstart" works but it does not help us with the outcome we want to obtain.

      We want to compare days or dates. we want to extrac the date from the datetime atribute and just then, compare  the dates.

      We have not managed to have this condition right and running. 

      Best regards,

      Juan Romero