Convert numeric value to date in VA Exploration 7.3

[jcrittenden]

I get the following results when trying to convert numeric to date using TreatAs in VA Exploration.  Any suggestions?

Thanks, Jane

[BrunoMueller · Accepted solution]

Hi

If possible, I would change the datasource, so that the value is already a proper date. If this is not possible, you can use the Format and Parse Operators to convert it like so

Parse(Format('someDate'n, 'BEST8.'), 'ANYDTDTE8.')

The TreatAs will convert a numeric value representing a SAS date to a date