Calender Object is not working properly when we are dealing with time

Wed, 25 Nov 2020 16:16:04 GMT

Hi I have scenario,

I have calendar object and my records are with time like below

2014/12/25 8:00

2014/12/25 11:00

I have created calendar object and with few years data.

Issue is if i select start date and end date it is not taking end date records becuase

end date is showing here is 2016/12/29 12:00:00 AM which is taking 2016/12/28 12:00:00 PM.

Please provide me the solution when we are dealing the calendar object with time scenarios.

Here if we select end date as 2016/12/30 then 2016/12/30 records will come other wise it won' come.

Actua;

If we select enddate as 2016/12/29 then 2016/12/30 records need be prsenet.

Please check, end date and do the needful

Regards

Thiru

Re: Calender Object is not working properly when we are dealing with time

settu_periasamy — Fri, 07 Apr 2017 10:33:36 GMT

Hi,

May be try with DayStart() and DayEnd() function.

if(isnull(GetFieldSelections(Starttime))=0 and isnull(GetFieldSelections(Endtime))=0,
Count({<YearMonth={">=$(=Date(DayStart(Vstartdate), 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(DayEnd(Venddate), 'YYYY/MM/DD h:mm:ss TT'))"},
Time = {"=(Frac(Time) + 1/86400) >= Time#(Starttime, 'h:mm TT') and (Frac(Time) - 1/86400) <= Time#(Endtime, 'h:mm TT')"}>} Country),
Count({<YearMonth={">=$(=Date(DayStart(Vstartdate), 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(DayEnd(Venddate), 'YYYY/MM/DD h:mm:ss TT'))"}>} Country))

topic Calender Object is not working properly when we are dealing with time in QlikView

Calender Object is not working properly when we are dealing with time

Re: Calender Object is not working properly when we are dealing with time