P21 seems to recognize Data Type through the value. I have many incomplete dates in my CMSTDTC, but when I set it to a complete date, I get CMSTDTC Data Type = “datatime” from P21.
I did more tests on the data, and as long as it contains incomplete dates, P21 will recognize it as “Text”. Why not identify the Data Type from the variable name – DTC?