Question

Migration Job - VALID_FROM

  • 1 December 2021
  • 3 replies
  • 66 views

Userlevel 7
Badge +16
  • Hero (Customer)
  • 548 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.


This topic has been closed for comments

3 replies

Userlevel 7
Badge +16

this is the screenshot.

Userlevel 7
Badge +20

Hi @ronhu 

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

 

Cheers!

Damith

Userlevel 7
Badge +16

@dsj Thank you.