I have a problem with converting a string value (example: GV_STR_DATE = 24/01/2018) to a date value, so I can fill a GV_DATE and DW_DATE fields which are of Date format. Can someone help me with that. Thank you in advance.
First of all you must enclosed your string in double quotes.
GV_STR_DATE = "24/01/2018"Then use the CDATE Function:GV_DATE = CDATE(GV_STR_DATE)
Phil RobsonSenior Director Support Americas