Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
////////////////////////
Hope this helps
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.
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.
Hope this helps
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;
Hi Anil, Can you please remove the files or change the naming of the file.
Thanks
I done my Job