excel date appears as number

[iliaisyah]

anyone can assist as my MMM-YY found as number

[petter · Accepted solution]

They sometimes do when you get a date from an Excel Workbook sheet. The way to remedy it is to wrap the field name in a Date()-function in the load in your load script to turn it into a real date.

LOAD

    .....

    Date(YOP) AS YOP,

    .....

[PabloTrevisan]

Use function Date with the mask you want .. like this:

Date(YOP,'MMM-YY') as YOP

[iliaisyah]

yes i already load as above and i get my time frame.

[vvvvvvizard]

Date(Date#(YOP)',MMM-YY') AS YOP

[petter]

You can also set the number format on the properties of the list box to "date" to get it shown right.