Date function

[#1]

Hi Friends

How do I get fiscal Month name like from Oct 2013, Nov 2013.... Sep 2014,

If I use MonthName(InvoiceDate,-3) it shows data of April 2014.

could you please how to do this.

[Anonymous]

try

monthname(addmonths(InvoiceDate,-3))

[amit_saini]

Chriss,

Try this:

dual(date(Datefield, 'MMM YY'), year(Datefield)*100+month(Datefield)) as MonthYear,

Thanks,
AS

[#4]

This should work.

[MarcoWedel]

please specify your question.

MonthName(InvoiceDate,-3)

delivering 'Apr 2014' would mean InvoiceDate is any date from July 2014 shifted by -3 months to April.

If you mean, you would like to get 'April 2014' instead of 'Apr 2014', then

Date(MonthName(InvoiceDate,-3), 'MMMM YYYY')

is what you are looking for.

hope this helps

regards

Marco

[MayilVahanan]

HI

Please refer

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year