topic Re: wrong year shown in calender object in QlikView https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460037#M171719 <HTML><HEAD></HEAD><BODY><P>hav kept it in m/d/yyyy format....</P></BODY></HTML> Tue, 11 Jun 2013 12:01:47 GMT 2013-06-11T12:01:47Z wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460031#M171713 <HTML><HEAD></HEAD><BODY><P>m using calender object, in tht, day and month are right but getting year as '- 5877'&nbsp; ?????//</P><P></P><P>my date is in QVW date format.</P></BODY></HTML> Tue, 11 Jun 2013 11:16:49 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460031#M171713 2013-06-11T11:16:49Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460032#M171714 <HTML><HEAD></HEAD><BODY><P>Hi try using Date () and DATE#() function and then try to get the year.</P></BODY></HTML> Tue, 11 Jun 2013 11:18:48 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460032#M171714 sujeetsingh 2013-06-11T11:18:48Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460033#M171715 <HTML><HEAD></HEAD><BODY><P>used #, still the same result</P></BODY></HTML> Tue, 11 Jun 2013 11:24:59 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460033#M171715 2013-06-11T11:24:59Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460034#M171716 <HTML><HEAD></HEAD><BODY><P>just give a sample </P></BODY></HTML> Tue, 11 Jun 2013 11:26:17 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460034#M171716 sujeetsingh 2013-06-11T11:26:17Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460035#M171717 <HTML><HEAD></HEAD><BODY><P>sorry cant share it but m using inputbox for the dates, which is already in date format</P><P></P><P>m doing some silly mistake</P></BODY></HTML> Tue, 11 Jun 2013 11:58:15 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460035#M171717 2013-06-11T11:58:15Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460036#M171718 <HTML><HEAD></HEAD><BODY><P>may be formatt of the date field in input box.</P></BODY></HTML> Tue, 11 Jun 2013 12:00:11 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460036#M171718 sujeetsingh 2013-06-11T12:00:11Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460037#M171719 <HTML><HEAD></HEAD><BODY><P>hav kept it in m/d/yyyy format....</P></BODY></HTML> Tue, 11 Jun 2013 12:01:47 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460037#M171719 2013-06-11T12:01:47Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460038#M171720 <HTML><HEAD></HEAD><BODY><P>kakey aaj ka pura din hi kharab hai......</P></BODY></HTML> Tue, 11 Jun 2013 12:02:54 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460038#M171720 2013-06-11T12:02:54Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460039#M171721 <HTML><HEAD></HEAD><BODY><P>hahah prasanth it happens some time..........Chill maro</P></BODY></HTML> Tue, 11 Jun 2013 12:03:58 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460039#M171721 sujeetsingh 2013-06-11T12:03:58Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460040#M171722 <HTML><HEAD></HEAD><BODY><P>in 3 yrs of qvw nvr gt stuck in such a mess, chalo bye.... thnks for the help</P></BODY></HTML> Tue, 11 Jun 2013 12:27:19 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460040#M171722 2013-06-11T12:27:19Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460041#M171723 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>m sending the application as well as the date have extracted frm the qvd used,</P><P>please see the year is still showing -5877</P></BODY></HTML> Wed, 12 Jun 2013 05:21:46 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460041#M171723 2013-06-12T05:21:46Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460042#M171724 <HTML><HEAD></HEAD><BODY><P>Anybody Pls.....</P></BODY></HTML> Wed, 12 Jun 2013 05:29:40 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460042#M171724 2013-06-12T05:29:40Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460043#M171725 <HTML><HEAD></HEAD><BODY><P>hav tried in number format bt result is same....</P></BODY></HTML> Wed, 12 Jun 2013 05:40:16 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460043#M171725 2013-06-12T05:40:16Z Re: wrong year shown in calender object https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460044#M171726 <HTML><HEAD></HEAD><BODY><P>Experts Advice Please....</P></BODY></HTML> Wed, 12 Jun 2013 05:49:24 GMT https://community.qlik.com/t5/QlikView/wrong-year-shown-in-calender-object/m-p/460044#M171726 2013-06-12T05:49:24Z