topic Re: Get the Current month and year in QlikView https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354586#M131611 <HTML><HEAD></HEAD><BODY><P>Hello Apurva,</P><P></P><P>I need one more favour Using Monthname(today()) I can get the Current Month and Year but when i try Monthname(today()-1) to get the previous month its not working..</P><P></P><P>Please help me...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Fri, 15 Jun 2012 10:51:59 GMT 2012-06-15T10:51:59Z Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354581#M131606 <HTML><HEAD></HEAD><BODY><P>Hello Friends</P><P></P><P>As I need to store the current month and Year in a variable, what is the function available to get it.</P><P></P><P>Regards</P><P></P><P>Chriss.....</P></BODY></HTML> Fri, 15 Jun 2012 06:52:02 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354581#M131606 2012-06-15T06:52:02Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354582#M131607 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>vCurrentYear= year(today())</P><P>vCurrentMonth= month(today())</P><P></P><P>Regards </P><P>Apurva</P></BODY></HTML> Fri, 15 Jun 2012 06:54:24 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354582#M131607 2012-06-15T06:54:24Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354583#M131608 <HTML><HEAD></HEAD><BODY><P>Hello Apurva,</P><P></P><P>Thanks for your reply, my requirement is I need to store the Month and Year in a single variable</P><P></P><P>like vCurrentMonYear = June 2012. is it possible ....</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Fri, 15 Jun 2012 06:59:10 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354583#M131608 2012-06-15T06:59:10Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354584#M131609 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> use this-&gt;&nbsp; vCurrentYM= monthname(today())</P><P></P><P> regards </P><P>Apurva</P></BODY></HTML> Fri, 15 Jun 2012 07:05:23 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354584#M131609 2012-06-15T07:05:23Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354585#M131610 <HTML><HEAD></HEAD><BODY><P>Thanks Apurva............</P></BODY></HTML> Fri, 15 Jun 2012 07:07:50 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354585#M131610 2012-06-15T07:07:50Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354586#M131611 <HTML><HEAD></HEAD><BODY><P>Hello Apurva,</P><P></P><P>I need one more favour Using Monthname(today()) I can get the Current Month and Year but when i try Monthname(today()-1) to get the previous month its not working..</P><P></P><P>Please help me...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Fri, 15 Jun 2012 10:51:59 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354586#M131611 2012-06-15T10:51:59Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354587#M131612 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Try this =Date(MonthName(Today())-1,'MMM YYYY')</P></BODY></HTML> Fri, 15 Jun 2012 11:22:42 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354587#M131612 jagannalla 2012-06-15T11:22:42Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354588#M131613 <HTML><HEAD></HEAD><BODY><P>Chris</P><P></P><P>No that will get the month name for yesterday. For the previous month use</P><P></P><P>MonthName(AddMonths(Today(), -1))</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Fri, 15 Jun 2012 11:24:03 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354588#M131613 jonathandienst 2012-06-15T11:24:03Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354589#M131614 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>use this</P><P></P><P>=MonthName(addmonths(today(),-1))</P><P></P><P>Regrds </P><P>Apurva</P></BODY></HTML> Fri, 15 Jun 2012 11:29:16 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354589#M131614 2012-06-15T11:29:16Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354590#M131615 <HTML><HEAD></HEAD><BODY><P>Yes, its works.... thanks a lot Apurva...</P></BODY></HTML> Fri, 15 Jun 2012 11:41:27 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354590#M131615 2012-06-15T11:41:27Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354591#M131616 <HTML><HEAD></HEAD><BODY><P>Your Welcome....</P></BODY></HTML> Fri, 15 Jun 2012 11:42:46 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354591#M131616 2012-06-15T11:42:46Z Re: Get the Current month and year https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354592#M131617 <HTML><HEAD></HEAD><BODY><P>sorry for the mistake...</P></BODY></HTML> Fri, 15 Jun 2012 11:56:15 GMT https://community.qlik.com/t5/QlikView/Get-the-Current-month-and-year/m-p/354592#M131617 jagannalla 2012-06-15T11:56:15Z