Calendar Days count between two date fields

Wed, 25 Nov 2020 16:16:04 GMT

Dear Experties ,

I have a one query regarding Calendar days & working days count between Two dates. As i count clendar days & working Days between ENDate - STARTDATE then i will get days , but if the start date and end date would same date it will gives us 0 instead of 0 i want to show as 1 day so how would do i acheive it . Please see the screen shot below as i expecting days are highlithed in red.

It would be helpful if anyone can provide the logic.

Re: Calendar Days count between two date fields

PrashantSangle — Mon, 05 Jun 2017 10:29:46 GMT

Hi,

write if condition like

if(startdate=enddate,1,yourexpression)

Regards,

Prashant

topic Re: Calendar Days count between two date fields in QlikView

Calendar Days count between two date fields

Re: Calendar Days count between two date fields