Date load from excel

[#1]

I am loading a file from excel

LOAD [Monthly data],

     [% Of local 3C's closed],

Monthly Data is JAN, FEB, MAR etc in Excel

but is coming across as 42005, 42036, etc

How can i convert this to show JAN, FEB etc within my load ?

Thank you

[sunny_talwar · Accepted solution]

Try this:

LOAD Month([Monthly data]) as [Monthly data],

     [% Of local 3C's closed],

[Chanty4u]

Hi,

use month function may be

LOAD month[Monthly data]   as  [Monthly data],

     [% Of local 3C's closed],

[swuehl]

To understand how this works using the numbers, have a look at

Get the Dates Right

and the tech doc that is linked at the bottom of this blog post.

[#5]

Thank you all for the help and info!