topic Re: How do get a date 320 days before a date? in QlikView https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049696#M636539 <HTML><HEAD></HEAD><BODY><P>Load *, Date(Transaction_Date-320) as New_Date;</P><P>Load</P><P>Date(MakeDate(2012) + Ceil(Rand() * 365)) as Transaction_Date</P><P>AutoGenerate 1</P></BODY></HTML> Mon, 18 Apr 2016 10:51:41 GMT MK_QSL 2016-04-18T10:51:41Z How do get a date 320 days before a date? https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049694#M636537 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have the following date field:</P><P></P><P>Date(MakeDate(2012) + Ceil(Rand() * 365)) as Transaction_Date</P><P></P><P>How can I get a date 320 days before the Transaction_Date above? This would be a new field in the script <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 18 Apr 2016 10:49:39 GMT https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049694#M636537 mwallman 2016-04-18T10:49:39Z Re: How do get a date 320 days before a date? https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049695#M636538 <HTML><HEAD></HEAD><BODY><P>date(Transaction_Date - 320)</P></BODY></HTML> Mon, 18 Apr 2016 10:50:31 GMT https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049695#M636538 Colin-Albert 2016-04-18T10:50:31Z Re: How do get a date 320 days before a date? https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049696#M636539 <HTML><HEAD></HEAD><BODY><P>Load *, Date(Transaction_Date-320) as New_Date;</P><P>Load</P><P>Date(MakeDate(2012) + Ceil(Rand() * 365)) as Transaction_Date</P><P>AutoGenerate 1</P></BODY></HTML> Mon, 18 Apr 2016 10:51:41 GMT https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049696#M636539 MK_QSL 2016-04-18T10:51:41Z Re: How do get a date 320 days before a date? https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049697#M636540 <HTML><HEAD></HEAD><BODY><P>Thank you both you are both correct <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 18 Apr 2016 11:03:47 GMT https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049697#M636540 mwallman 2016-04-18T11:03:47Z Re: How do get a date 320 days before a date? https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049698#M636541 <HTML><HEAD></HEAD><BODY><P>If you got what you were looking for, please close the thread by marking the correct answer</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Mon, 18 Apr 2016 11:30:37 GMT https://community.qlik.com/t5/QlikView/How-do-get-a-date-320-days-before-a-date/m-p/1049698#M636541 sunny_talwar 2016-04-18T11:30:37Z