Change a String to date.

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

Date Time

Accepted answers

@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
We can also use the DateTime Tool which is might be easier to understand.

0622-DataPirate26.yxmd

All comments

@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

That worked perfectly. Thanx for the quick help.

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

0622-DataPirate26.yxmd

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

@DataPirate26
Good to know it helps.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703