I have a text formatted line item which is a date .I want to convert it to Date format .
I tried to break it into three Year ,Month and day using
It works for 12/10/2012 but what about 2/3/2012 ??
Note -- Can't change source text to date format .
Go to Solution.
You have to identify the day, month, year using the seperators (/). Find the seperator position using the function FIND. Seperate the text between the seperators, using MID.
You have to use a combination of FIND, MID and LEN functions to do it.
Avoid hardcoding the parameters of the syntax - There are many functions that can be put to use here as @ArunManickam already mentioned. FIND, MID,LENGTH,VALUE,RIGHT,LEFT,DATE
Hope that helps
Thanks for detailed explanation. Looks like it will solve my problem .