IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

  • 1.  Date comparison:

    Posted 08/20/10 05:17 AM

    Originally posted by: Mr wtx


    Is there a way to compare 2 dates in wtx?I looked at several date functions and could not get any idea.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Date comparison:

    Posted 08/20/10 06:01 AM

    Originally posted by: SystemAdmin


    what comparison are you trying to make? A simple IF (date1 > date2, X, Y) should work.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Date comparison:

    Posted 08/20/10 11:56 AM

    Originally posted by: gspvish


    DATETONUMBER function returns in integer the number of days since December 31, 1864 to the specified date.
    So
    1. DATETONUMBER(DATE_A) > DATETONUMBER (DATE_B) can be used to compare dates
    2. DATETONUMBER (DATE_A) - DATETONUMBER (DATE_B) gives days between the two dates.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: Date comparison:

    Posted 08/25/10 06:05 AM

    Originally posted by: maddysam


    Reg point1 , I hope that conversion function(DATETONUMBER) not required when we are comparing dates. But required in case of using any arithmetic operator(as in point2)
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange