topic Date problems in QlikView https://community.qlik.com/t5/QlikView/Date-problems/m-p/824958#M1025706 <HTML><HEAD></HEAD><BODY><P>Need a little help.</P><P></P><P>I have a line chart that as a date axis but what i want to do is just show the day and the month as I have a fiscal year picker. So example 01/04 and not have 01/04/2013 and 01/04/2014. I have got =MID(Referral_Date,1,5) and this works great in a txt box but not on my line chart I get 41365 which is an excel date. Any help or guidance is much appreciated.</P></BODY></HTML> Wed, 04 Mar 2015 09:37:38 GMT 2015-03-04T09:37:38Z Date problems https://community.qlik.com/t5/QlikView/Date-problems/m-p/824958#M1025706 <HTML><HEAD></HEAD><BODY><P>Need a little help.</P><P></P><P>I have a line chart that as a date axis but what i want to do is just show the day and the month as I have a fiscal year picker. So example 01/04 and not have 01/04/2013 and 01/04/2014. I have got =MID(Referral_Date,1,5) and this works great in a txt box but not on my line chart I get 41365 which is an excel date. Any help or guidance is much appreciated.</P></BODY></HTML> Wed, 04 Mar 2015 09:37:38 GMT https://community.qlik.com/t5/QlikView/Date-problems/m-p/824958#M1025706 2015-03-04T09:37:38Z Re: Date problems https://community.qlik.com/t5/QlikView/Date-problems/m-p/824959#M1025708 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use</P><P>if it is Dimension then use Condional Dimesion</P><P></P><P>Date(FieldName,'DD/MM')</P><P></P><P>Regards</P></BODY></HTML> Wed, 04 Mar 2015 09:39:57 GMT https://community.qlik.com/t5/QlikView/Date-problems/m-p/824959#M1025708 PrashantSangle 2015-03-04T09:39:57Z Re: Date problems https://community.qlik.com/t5/QlikView/Date-problems/m-p/824960#M1025709 <HTML><HEAD></HEAD><BODY><P>Thanks Max.</P></BODY></HTML> Wed, 04 Mar 2015 09:44:53 GMT https://community.qlik.com/t5/QlikView/Date-problems/m-p/824960#M1025709 2015-03-04T09:44:53Z