How to Convert A Date in Internal or External Format?
Answer
One can do it by doing following steps:
Use the functions modules CONVERT_DATE_TO_EXTERNAL or CONVERT_DATE_TO_INTERNAL to convert the date.
When converting to external format, the date format from the user's user profile will be used. When converting to internal format, the result will be in YYYYMMDD format.