IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
Back to discussions
Expand all | Collapse all

WTX Extract function to return records between a date range

  • 1.  WTX Extract function to return records between a date range

    Posted 01/25/13 11:10 AM

    Originally posted by: SystemAdmin


    I am attempting to return a set of records where the date (Date Fields:Record:AcctGroup) is greater than or equal to a date(3StartDateTag:BDX) that I am passing like this:

    =f_bALANCE(EXTRACT(Record:AcctGroup, DATETONUMBER(3StartDateTag:BDX) > DATETONUMBER(Date Fields:Record:AcctGroup)))

    The EXTRACT function works great when I use "=" but when I use ">=" or ">" the maps builds but returns the value from the first record not the record that is ">=" several records down.

    Any help would be appreciated.

    Thanks
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


Related Content