topic Re: Calculating number of days between two date fields in QlikView https://community.qlik.com/t5/QlikView/Calculating-number-of-days-between-two-date-fields/m-p/1259146#M397471 <HTML><HEAD></HEAD><BODY><P>(Real) dates are just numbers - therefore you could calculate: Date2 - Date1. If they are not dates than you need to convert them with date#() and maybe with floor() to cut a time-part.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 16 Nov 2016 12:36:17 GMT marcus_sommer 2016-11-16T12:36:17Z Calculating number of days between two date fields https://community.qlik.com/t5/QlikView/Calculating-number-of-days-between-two-date-fields/m-p/1259145#M397470 <HTML><HEAD></HEAD><BODY><P>Hi ... I want to calculate the number of days between two date fields in MM/DD/YYYY format. </P><P></P><P>What would be the best way ?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 16 Nov 2016 12:32:03 GMT https://community.qlik.com/t5/QlikView/Calculating-number-of-days-between-two-date-fields/m-p/1259145#M397470 2016-11-16T12:32:03Z Re: Calculating number of days between two date fields https://community.qlik.com/t5/QlikView/Calculating-number-of-days-between-two-date-fields/m-p/1259146#M397471 <HTML><HEAD></HEAD><BODY><P>(Real) dates are just numbers - therefore you could calculate: Date2 - Date1. If they are not dates than you need to convert them with date#() and maybe with floor() to cut a time-part.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 16 Nov 2016 12:36:17 GMT https://community.qlik.com/t5/QlikView/Calculating-number-of-days-between-two-date-fields/m-p/1259146#M397471 marcus_sommer 2016-11-16T12:36:17Z Re: Calculating number of days between two date fields https://community.qlik.com/t5/QlikView/Calculating-number-of-days-between-two-date-fields/m-p/1259147#M397472 <HTML><HEAD></HEAD><BODY><P>=date(Field_name,'MM/DD/YYYY')- date(Field_name,'MM/DD/YYYY')</P></BODY></HTML> Wed, 16 Nov 2016 12:46:24 GMT https://community.qlik.com/t5/QlikView/Calculating-number-of-days-between-two-date-fields/m-p/1259147#M397472 eromiyasimon 2016-11-16T12:46:24Z