Skip to main content

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 is the screenshot.

Hi @ronhu 

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

 

Cheers!

Damith

@dsj Thank you.

Terms & ConditionsCookie settings