topic Re: Problem Date in QlikView https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453173#M169082 <HTML><HEAD></HEAD><BODY><P>Any Help!</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 28 Sep 2012 17:05:51 GMT pgalvezt 2012-09-28T17:05:51Z Problem Date https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453172#M169081 <HTML><HEAD></HEAD><BODY><P>Hello, I'm having problem with the format date I have this in my script:</P><P></P><P></P><P>MonthName(FieldName)-1 as Month,</P><P>MonthName(Date(FieldName,'MMM-YY'))-31 as Period,</P><P></P><P>But Oct appear like as number </P><P></P><P>Thanks!</P></BODY></HTML> Fri, 28 Sep 2012 16:11:37 GMT https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453172#M169081 pgalvezt 2012-09-28T16:11:37Z Re: Problem Date https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453173#M169082 <HTML><HEAD></HEAD><BODY><P>Any Help!</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 28 Sep 2012 17:05:51 GMT https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453173#M169082 pgalvezt 2012-09-28T17:05:51Z Re: Problem Date https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453174#M169083 <HTML><HEAD></HEAD><BODY><P>What is the source format of the date? I am guessing you have already tired to format the date on the UI side using the number tab.</P></BODY></HTML> Fri, 28 Sep 2012 17:31:18 GMT https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453174#M169083 regowins 2012-09-28T17:31:18Z Re: Problem Date https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453175#M169084 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Try like this</P><P></P><P>Month(DateFieldName) as Month</P><P></P><P>If you use MonthName(DateFieldName)-1 gives number..</P><P></P><P>So please use Month() or MonthName() function</P><P></P><P>Hope that helps</P></BODY></HTML> Fri, 28 Sep 2012 19:22:36 GMT https://community.qlik.com/t5/QlikView/Problem-Date/m-p/453175#M169084 MayilVahanan 2012-09-28T19:22:36Z