String to Date Conversion-1530487085

Posted Sun, 01 Jul 2018 21:18:05 GMT by Davorin Plemenitaš

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.

Posted Mon, 02 Jul 2018 09:05:49 GMT by Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

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

You must be signed in to post in this forum.

Get Help