Please help me to transform the "date" variable to real date form "YYYYMMDD". I have tried everything but failed. Really don't know why. The data file is attached.

Thank you!