I have a string field where the data is as 20160826(YYYYMMDD). The first 4 letters is the year the next 2 is the month and the last 2 is the date. I want to change this Field to date format. Output will show as ( 2016-08-26). Can someone help me to achieve this
Solved! Go to Solution.
you would like to use the datetimeparse() function.
%Y is there for digit year, %m and %d are the month and day specified.
Daterimeparse([text],"%Y%m%d")
when used to define a new date field this will work for you.
cheers,
mark
That worked perfectly. Thanx for the quick help.
@DataPirate26
We can also use the DateTime Tool which is might be easier to understand.
Sorry for the delayed response. This also worked perfectly. Thanx for all your help and suggestions
@DataPirate26
Good to know it helps.