List box dates

[#1]

Hi All

The cells under a column of mine Excel file shows dates as follows: "December 2016 Final".

When creating a date listbox in Excel the same format is being used > How am I able to change the appearance more like below image?

////////////////////////

[Anil_Babu_Samineni]

May be do this

Load Year(Fields) as Year, Month(Fields) as Month;

Load Fields from Table;

Can you create List box and then change these options on presentation tab. If still it shows 2 columns you can drag to the right.

[#3]

So let me make it a bit more clear.

My excel shows dates as follows: "December 2016 Final" (this is one cell)

I am trying to make QV read the first word as Month, second word as Year and ignore the last word.

[Anil_Babu_Samineni · Accepted solution]

Hope this helps

[tamilarasu]

Hi Meron,

Try this,

LOAD

Date(Date#(Subfield(Field_Name,' ',1),'MMM'),'MMM') as Month,

Date(Date#(Subfield(Field_Name,' ', 2),'YYYY'),'YYYY') as Year

FROM

Excel Source;

[#6]

Hi Anil, Can you please remove the files or change the naming of the file.

Thanks

[Anil_Babu_Samineni]

I done my Job