String to Date Conversion-1530487085

Hello all,

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 Robson
Senior Director Support Americas