topic Fiscal year format in QlikView https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165159#M37586 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use Date(Due_Date,'DD-MM-YYYY') or Date(Due_Date,'MM-DD-YYYY') e.t.c for changing the format.</P><P></P><P>Regards,</P><P>Ravi</P></BODY></HTML> Wed, 18 Aug 2010 07:23:42 GMT 2010-08-18T07:23:42Z Fiscal year format https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165158#M37585 <HTML><HEAD></HEAD><BODY><P>Hey guys.</P><P>I finally got fiscal year working and every things cool 100%. Only problem is that its seems to be in a different format. it looks like this:</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2164_sourceID:2164" /></P><P></P></BODY></HTML> Wed, 18 Aug 2010 07:19:16 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165158#M37585 2010-08-18T07:19:16Z Fiscal year format https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165159#M37586 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use Date(Due_Date,'DD-MM-YYYY') or Date(Due_Date,'MM-DD-YYYY') e.t.c for changing the format.</P><P></P><P>Regards,</P><P>Ravi</P></BODY></HTML> Wed, 18 Aug 2010 07:23:42 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165159#M37586 2010-08-18T07:23:42Z Fiscal year format https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165160#M37587 <HTML><HEAD></HEAD><BODY><P>I have already tried those formulas and ive tried date(date#(OrderDate),'YYYY/MM/DD'),'DD/MM/YYYY') and nothing works</P></BODY></HTML> Wed, 18 Aug 2010 07:45:43 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165160#M37587 2010-08-18T07:45:43Z Fiscal year format https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165161#M37588 <HTML><HEAD></HEAD><BODY><P>Hi Blaze</P><P>Then you use makedate() funcation.</P><P></P><P>Regards</P><P>Ashish</P></BODY></HTML> Wed, 18 Aug 2010 08:24:01 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165161#M37588 2010-08-18T08:24:01Z Fiscal year format https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165162#M37589 <HTML><HEAD></HEAD><BODY><P>Got it working. problem was that the raw data was in a timestamp format. The soluton i used was this</P><P></P><P>LOAD Date(Floor(OrderDate)) as OrderDate,</P></BODY></HTML> Wed, 18 Aug 2010 08:28:03 GMT https://community.qlik.com/t5/QlikView/Fiscal-year-format/m-p/165162#M37589 2010-08-18T08:28:03Z