How to convert date from jan 22 2106 to 20160122??

[Former Member]

Hi everyone i just want know how to convert string date format to standard sap format lik(yyyymmdd) by using Calculated columns

Thanks

[pfefferf]

Hello Nari,

you can use a calculated column with SQL language using functions TO_DATE and TO_NVARCHAR to reach your goal. Check following example.

Calculated Column (column "DATE_STRING" contains the date value in your described original format):

Result:

Of course it would be nicer to use function TO_DATS (which converts a date into the ABAP Date format) instead of TO_NVARCHAR, but this function is not supported in a calculated column at point of time writing this.

Regards,
Florian