The required date format is not a date format. But you can achieve this in string format.
Split your integer field into year,Month & day. And set as per your requirement.
If you attached the workbook then i can help you.
If you still need it to be a date then create a calc field:
DateParse("YYYYMMDD", [Your Field])
And then format it to:
YYYY \Year\s MM \M\o\nt\h DD \da\y\s
Another approach can be.
1. First Convert your column or value to string and use DATEPARSE function to make it into Date format
Calc Date : DATEPARSE('yyyyMMdd','20171005')
2. Below will give the format you are looking or play around with Date functions as per requirement
STR(year([Calc Date]))+' Years '+STR(month([Calc Date]))+' Month '+STR(day([Calc Date]))+' days'
Thanks a lot subrakant,fr giving urs imp time and helping me.
Depending on your locale settings, you can usually get away with just right clicking on the field itself >Change Data Type > Date
While this is pretty reliable in my locale, it is not universally applicable. Failing that simple solution, the DATEPARSE function Keerthana mentioned is the most reliable.