Hi Jonathan Espinal,
You can get the solution by manually, creating the Calculations to extracting Parts of the Date then make it as Date.
int( "20"+MID([Field], 2,3) )
4) Getting Actual Date
Date( str( [Year] ) + "/" + str ([Month] ) + "/" + str([Day])
I did not test the above calculations, Since you need it urgently.
Hi @Tableau kumar
Thanks for your time!
I try it and it's working, but there's one little detail, The calculated field for the actual date returns five values in the year like this "19991" the last digit of the date is wrong, I don't need it so how can I get rod out of that last digit?
And actually the date como in a two digit format for example one record comes like this, 1 0 0 0 5 1 8 wich means the date is 18/05/00
with the calculated fields I extract what I need but how can I format that field of the actual date?