Multiple date conversions in one field.

[Former Member]

Hello SAPians..

I have source date column having the data in the form of DD-MM-YYYY, YYYY.MM.DD and  MM/YYYY/DD format.

What I want to do is I want to integrate them into one format.

So please guide me first how to differentiate which records have following

[Former Member · Accepted solution]

Hi Vaishaali,

You can use the string functions to find -,.,/ based on which you can differentiate them using a case transform and them use to_date or to_char to convert into system format or your given format.

Regards,

Sandeep

[Former Member]

Can you please provide me the code logic by taking one sample scenario.

--Thanks in advance.

[Former Member]

Add a new column map it to decode(index(date,'.',1) is not null,'DOT',index(date,'-',1) is not null,'DASH','SLASH'). Here date is column which contains the possible dates. The Output result will look as below. Then place a case tranform to seperate it.

Date	Seperator
YYYY.MM.DD	DOT
DD-MM-YYYY	DASH
MM/YYYY/DD	SLASH