Hi, I've my Date field as text in the following format, i would like to convert it to Date format
01-FEB-18 is the data in my DB
i would like to convert it to 01.02.2018
LOAD * INLINE [
Date(Date#(dateformat,'DD-MMM-YY'),'DD.MM.YYYY') AS Newdate
View solution in original post
You can go through below document for mixed date formats.