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.  Calculate time elapsed between two dates & times

    Posted 07/15/04 04:14 AM

    Originally posted by: SystemAdmin


    I've been working on this for weeks. Does anyone have a map that does this? I'm running a batch file to do a DIR command on several folders. I then pull the files out of the results and write those to another file. Now I need to read the date and time and compare it to the current date and time and email the results of any file over x minutes old.

    Example:
    200407150807 CURRENTDATETIME
    200407141500 file date and time
    ==========
    <difference in minutes> (of course, just subtracting them won't work)

    IF(<difference in minutes> > 30, write-recs, NONE)
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Calculate time elapsed between two dates & times

    Posted 07/15/04 05:18 AM

    Originally posted by: SystemAdmin


    Sarbo,

    I have a solution to this problem which I can send to you. Please send an email to NETechSupport@Ascential.com and mark it for my attention.

    Thank-you.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: Calculate time elapsed between two dates & times

    Posted 07/15/04 05:30 AM

    Originally posted by: SystemAdmin


    The output from my map:

    There are 1027 minutes between the input times.

    Hope this helps.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange