B2B Integration

Sterling B2B Integration

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

 View Only
  • 1.  Date manipulation

    Posted Thu November 12, 2020 07:23 AM
    My customer has provided me with a due date of 200006 (yymmww) which represents Week 6 of 2020.
    I need to determine what is the Monday date of that week.

    What is the best practice and easiest way to obtain this date?

    ------------------------------
    Gwen Sea
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: Date manipulation

    Posted Thu November 12, 2020 10:39 AM
    If you are doing translation you can handle it in B2Bi Map by creating Date Format for your date, and map/link that element to output element with required date format. Note that B2Bi mapping has %W - Week of the year as a decimal number, with Monday as the first day of the week (00 - 51), and %U - if Sunday is the start day of the Week.

    If you are not doing any translation and would like to handle it in BP then a JAVA Task service might be a good option. You might also try date conversion on DB using LWJDBC.

    ------------------------------
    Rajasekhar Muthamsetty
    ------------------------------