topic Re: Only require last 30 days back order in QlikView https://community.qlik.com/t5/QlikView/Only-require-last-30-days-back-order/m-p/391019#M145835 <HTML><HEAD></HEAD><BODY><P>Hi Nayan,</P><P></P><P>Use the following Formula given below.</P><P></P><P>Back_Order_Date &gt;= Date(Today()-30)</P><P></P><P>This will give Back_Order_Dates greater than 08-Sep-2012.</P><P></P><P>Jagan.V</P><P></P></BODY></HTML> Mon, 08 Oct 2012 13:43:21 GMT qv_jagan 2012-10-08T13:43:21Z Only require last 30 days back order https://community.qlik.com/t5/QlikView/Only-require-last-30-days-back-order/m-p/391018#M145834 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am doing a report where I only require the last 30 days back orders.&nbsp; Basically I require all back orders in the last month (ie from 30 days before to current date.How do you create a formula for this.</P><P></P><P>kind regards</P><P>Nayan</P></BODY></HTML> Mon, 08 Oct 2012 13:36:05 GMT https://community.qlik.com/t5/QlikView/Only-require-last-30-days-back-order/m-p/391018#M145834 2012-10-08T13:36:05Z Re: Only require last 30 days back order https://community.qlik.com/t5/QlikView/Only-require-last-30-days-back-order/m-p/391019#M145835 <HTML><HEAD></HEAD><BODY><P>Hi Nayan,</P><P></P><P>Use the following Formula given below.</P><P></P><P>Back_Order_Date &gt;= Date(Today()-30)</P><P></P><P>This will give Back_Order_Dates greater than 08-Sep-2012.</P><P></P><P>Jagan.V</P><P></P></BODY></HTML> Mon, 08 Oct 2012 13:43:21 GMT https://community.qlik.com/t5/QlikView/Only-require-last-30-days-back-order/m-p/391019#M145835 qv_jagan 2012-10-08T13:43:21Z Re: Only require last 30 days back order https://community.qlik.com/t5/QlikView/Only-require-last-30-days-back-order/m-p/391020#M145836 <HTML><HEAD></HEAD><BODY><P>Thanks Jagan</P></BODY></HTML> Mon, 08 Oct 2012 13:59:49 GMT https://community.qlik.com/t5/QlikView/Only-require-last-30-days-back-order/m-p/391020#M145836 2012-10-08T13:59:49Z