Forum Discussion
Help on Date Format conversion
I have 2 Excel files with a Source that has this Column 'Date' (see below) in my 1 Excel it converts fine but in the other it converts it to Month as Date and Date as month see other image below. ...
You need to convert the Date Column to Date format before doing Date.ToText. Right now it looks like you are performing a Date Operation on a text column.
--Nate
Actually that is the very first thing that anyone will do even the system will automatically convert your data after you promote to Headers BUT converting this to date will yeild the same result that is why what your seeing are non-convetional approach.
Converting immediately (as usual) to date will result to January 3, January 4, January 5..... instead of March 1, April 1 and May 1