Hi.
I would like to know whether it is possible to parse data from a corresponding Text Column and then result it to a Date Column.
Text Column Sample Data - 831028-99-9999 (YYMMDD-XX-XXXX)
Y - Year, M - Month, D - Day and X - Not Applicable
Date Column (To Display) - 28 Oct, 1983
I compiled the following formula and it is working.
FORMAT_DATE(DATE(LEFT({NRIC}, 2), RIGHT(LEFT({NRIC}, 4),2),RIGHT(LEFT({NRIC}, 6),2)),“DD MMM YYYY”)
Text Column Sample Data - 831028-99-9999
Date Column (To Display) - 28 Oct 1983
Hope this is able to assist anyone which are working on such data.
However, whenever I had change the DATE value to 35 ( 831035, YYMMDD, which does not exists) it would come out to the following result - 04 Oct 1983.
Is it an industry standard or should it come out an error?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.