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 .

[#2]

Hi Max,

Can you please provide the solution in qvw file.

I am not getting output using the same expression.

Thanks in Advance

Sreehari

[PrashantSangle]

Hi,

Your expression is fine. I did not made any changes to your posted QVW.

It is strange for me that why it is giving you wrong result.

Regards

[#4]

Hi Max,

FYI ,for me there were no data for 'FY14 Jun' month was only having 'FY14 May' and 'FY14 Mar'.

But unluckly for me the Date# function is not working properly.

Thanks for your support.

[anbu1984]

Check this app

[#6]

Hi Anbu Cheliyan,

Thanks for your reply

Actually this issue is having connection another thread which you only provided the solution(get the count of unique for a month also if it is repeating again in next month or occured before in...)

The issue is that when I use Date#(Field,'MMM YYYY') it is not giving the correct output .

I think order by is creating the issue,Can you please help me solving the issue and it will be a great help.

Thanks in Advance

Sreehari

[anbu1984]

Check this app