Change date format!!

[Anonymous]

hi all..I have a scenario where i read data from the excel spreadsheet which has a date column of format(MMM YYYY), but it is interpreting the data present in that column as an integer..my dates are like [42644.0] for oct 2016, [42614.0] for sept 2016 and so on..I tried everything but nothing worked for me..I guess QV is taking it as text.. In This case how do i proceed as to get the desired output in the MMM YYYY format..please help!!

[vinieme12]

Date#(fieldname,'MMM  YYYY') as fieldname

Or

Date(fieldname,'MMM  YYYY') as fieldname

Use the above during load

[jonathandienst]

The underlying value in  Excel is the date number, so all you need in QV is to format it as a date:

     Date(FieldName) as Date

[Anonymous]

guys thanks for help..but didn't work for me..I've tried like almost everything..can't fix it..QV is reading it as text..num(), num#(), alt(), date() or date#() none are working..is there any other way out to fix this?

[vinieme12]

go to Number Tab >> Select Date >> in format expression type MMM YYYY

or post the app the demonstrates the problem

[buzzy996]

sample app,pls?

[buzzy996]

or try this way :

Date(AddYears(Date(Date#('19'&Right(yrdatefield,6),'YYYYMMDD'),'DD/MM/YYYY')

          ,100*Left(yrdatefield,1)),'DD/MM/YYYY') As  NewDatefield;

[sangeess21]

Goto Settings--> Document Properties-->Number tab--> Select the date field and change the number format settings to Date. (Change the format pattern to MMM/YYYY)

Thanks,

Sangeetha