Skip to Content
avatar image
Former Member

date transform

Should i open an oss message for date transform function when source date is 0000-00-00?

Florin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 19, 2007 at 12:55 PM

    Hi,

    No need,

    The Function is available.In Message Mapping under Date Function you can find transform date function.

    Regards

    Agasthuri Doss

    Add comment
    10|10000 characters needed characters exceeded

    • Even though you receive this from your sender system, why would you want to send it to target system, since it doesn't hold a valid value?

      Just use an If without else and for condition use date different from "0000-00-00".

      Regards,

      Henrique.

  • avatar image
    Former Member
    Sep 19, 2007 at 01:08 PM

    Yes Floring ,

    As Doss said.... u can transform any date format ....using the "DateTrans" function under "Date" standard function....

    u can transform yyyy:mm:dd to mm:dd:yyyy

    yyyy:dd:mm to yyyy:mm:dd

    dd:mm:yyyy to mm:yyyy:dd

    yyyy:mm:dd to dd:mm:yyy

    any format u want.......

    double click on the DateTrans function there u can give the sorce date format...and also u can give the target date format.. as ur requirement....just check it ...give a try.. it will work..

    all the best...

    Regards

    Biplab

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      just try to use 0000-00-00 as a date source. this was the problem, but can be catched with if statement.

      Florin

  • Sep 19, 2007 at 01:12 PM

    Flroin,

    I think we discussed the transofrmation long back. I forgot it, can u tell how the date should be transformed.

    raj.

    Add comment
    10|10000 characters needed characters exceeded