Skip to main content
Question

Migration Job - VALID_FROM

R
Hero (Customer)
Forum|alt.badge.img+16
  • ronhu
  • Hero (Customer)
  • 621 replies

Community, 

i am doing supplier price list migration job, INSERT, one default filed i would like to have it defaulted to “03-31-2022”. but the issue is, whatever i changed the date format, system always prompted me error.

how to correct this?

 

Thank you.

Ron
    This topic has been closed for comments

    3 replies

    R
    Hero (Customer)
    Forum|alt.badge.img+16
    • ronhu
    • Author
    • Hero (Customer)
    • 621 replies
    • December 1, 2021

    this is the screenshot.

    Ron
    dsj
    Superhero (Partner)
    Forum|alt.badge.img+22
    • dsj
    • Superhero (Partner)
    • 831 replies
    • December 2, 2021

    Hi @ronhu 

    use TO_DATE('3/31/2022', 'MM/DD/YYYY')

     

    Cheers!

    Damith

    DSJ - https://dsj23.me
    R
    Hero (Customer)
    Forum|alt.badge.img+16
    • ronhu
    • Author
    • Hero (Customer)
    • 621 replies
    • December 2, 2021

    @dsj Thank you.

    Ron
    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings