Change a String to date.

[DataPirate26]

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

[MarqueeCrew · Accepted solution]

@DataPirate26 ,

 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

[DataPirate26]

That worked perfectly. Thanx for the quick help.

[Qiu · Accepted solution]

@DataPirate26 
We can also use the DateTime Tool which is might be easier to understand.

[DataPirate26]

Sorry for the delayed response. This also worked perfectly. Thanx for all your help and suggestions

[Qiu]

@DataPirate26 
Good to know it helps.