topic Re: Date Calculation in QlikView https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1353#M794371 <HTML><HEAD></HEAD><BODY><P>Sorry, that should be 185 Weeks, not 209!</P></BODY></HTML> Tue, 16 Jan 2018 10:08:00 GMT Anonymous 2018-01-16T10:08:00Z Date Calculation https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1352#M794369 <HTML><HEAD></HEAD><BODY><P>Morning,</P><P></P><P>I need to create a weeks figure, based on the time that an item has been on offer for sale, or TOO (Time on Offer). For example, I have an item which launched on 01/07/2014 today's date is 16/01/2018 so the TOO would be 209 Weeks. The data being provided by the SQL table is DATETIME, so i'm also not sure if I need to cater for this.</P><P></P><P>Any help is appreciated.</P><P></P><P>Regards</P><P></P><P>David</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1352#M794369 Anonymous 2020-11-25T16:16:04Z Re: Date Calculation https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1353#M794371 <HTML><HEAD></HEAD><BODY><P>Sorry, that should be 185 Weeks, not 209!</P></BODY></HTML> Tue, 16 Jan 2018 10:08:00 GMT https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1353#M794371 Anonymous 2018-01-16T10:08:00Z Re: Date Calculation https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1354#M794372 <HTML><HEAD></HEAD><BODY><P>Hi David,</P><P></P><P>You should be able to write something like this in your load script:</P><P>(Today() - [YourDateField]) / 7 AS TOO</P><P></P><P>You can also either Ceil() or Floor() the result depending on what you want.</P><P></P><P>-Teemu</P></BODY></HTML> Tue, 16 Jan 2018 10:17:08 GMT https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1354#M794372 teempi 2018-01-16T10:17:08Z