Not able to format the Date

[#1]

Hi Team,

I am not able to combine  Month and Year field to have it in a format MonthYear(like Mar2014) format only for May Month.

Month format is FY14 Mar and Year format is FY2014,So when I combine New field using formula

Date#(Date#(right(Month,3),'MMM')&right(Year,4),'MMMYYYY')  it should give Mar2014 and May2014.But still Month for F14 May is showing as Mar2014,

For your reference I am attaching both the qvw and sample excel .

[danieloberbilli]

try this

[PrashantSangle]

Hi,

I am getting desired result.

Please find below screen shot .

Regards,

[#4]

Hi All,

Just want to know why only for month May it is not working and one time formula i.e Date#(Date#(right(Month,3),'MMM')&right(Year,4),'MMMYYYY')  is not working.

Can anyone provide me the solution with qvw as attached.

Thanks for your feedback.

Sreehari

[danieloberbilli]

I see what you mean - you need an additional Date() format function:

I was also confused why May is still March in my previous example...check this out:

[sujeetsingh]

It use Date() function for the same

[PrashantSangle]

Hi,

Well It is screen shot of your report with your expression only.

I did not made any changes to your existing expression. and I am getting expected result as you mention in your post.

Here I am getting May 2014 for FY14 May

Regards

[#8]

Hi Daniel,

Thanks for your solution,

Sorry I am getting confused which field I have to take as the  correct one.

It will be good if you provide the solution as qvw file.

Regards,

Sreehari

[danieloberbilli]

PFA -

CorrectDate_final is identified by Qlik as a real date field

CorrectDate is not identified as date field but a string value only

[#10]

Hi ,

I am not getting the correct output which I want.

Still May is mapped to March only.

Thanks Daniel