This part actually looks simple and straight forward. All I did was, go to data format property of the column date and set the pattern to MMDDYYYY. But the interesting part was that, the output was stranger; something like 041042009.
I was thinking, why the day is in 3 digits instead of 2? The reason being it counts the days from the start of the year. So if you want to use the MMDDYYYY format keeping the days to 2 digits, then you need to write the pattern as MMddYYYY. Isn’t it silly?
