unable to convert character value into date

[rohithverma]

Intially i had a ".XLSB " formatted file which i have  saved in format as  ".XLSX" file. But the dates present in XLSB are converted into character in ".XLSX"  .So while applying any date format for this it was taking as year 2080 but not the present year.

For example in ".XLSB" the format is "28-JAN-2020" while after converting into ".XLSX" the same value is converted to "43858:"

and when i tried to apply format for this it was converting into "28-JAN-2080".

Please help me on this.

[PaigeMiller]

https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Conversion-from-Excel-Date-to-SAS...

[Kurt_Bremser]

Add

'30dec1899'd

to this value, and apply a SAS date format.