topic Re: How to get the diff betweem two date values ? in QlikView

How to get the diff betweem two date values ?

suvechha_b — Thu, 06 Aug 2015 08:31:29 GMT

Please help me in writing the following expression :

Max((Date(Date#([Start Date],'DD/MM/YYY'),'YYYY/MM/DD'))-Min((Date(Date#([Exp End Date]),'DD/MM/YYYY'),'YYYY/MM/DD'))

Eg ,

[Start Date] : '2014-11-03 00:00:00.000'

[Exp End Date]: '2015-08-03 00:00:00.000'

Result : 273

sunny_talwar — Thu, 06 Aug 2015 08:41:32 GMT

Try this:

=Date#(Left('2015-08-03 00:00:00.000', 10), 'YYYY-MM-DD') - Date#(Left('2014-11-03 00:00:00.000', 10), 'YYYY-MM-DD')

suvechha_b — Thu, 06 Aug 2015 08:44:28 GMT

Sorry .... My Date format is like this : DD/MM/YYYY

[Start Date]:03/11/2014

[Exp End Date]:03/08/2015

sasiparupudi1 — Thu, 06 Aug 2015 08:48:40 GMT

=Max(Date#(SubField([Start Date],' ',1),'YYYY-MM-DD'))-Min(Date#(SubField([Exp End Date],' ',1),'YYYY-MM-DD'))

sasiparupudi1 — Thu, 06 Aug 2015 08:50:55 GMT

=Max(Date#([Start Date] ,'DD/MM/YYYY'))-Min(Date#([Exp End Date],'DD/MM/YYYY'))

maxgro — Thu, 06 Aug 2015 08:51:14 GMT

if you have 2 dates fields

[Exp End Date] - [Start Date]

if you have 2 date and time and you want the difference in days

floor([Exp End Date]) - floor([Start Date])