Date Range and time range is not working

[#1]

Hi

I have scenario.

Need to select date range and time range using filters.For that i have created two calendar object with variables.

In addition to this i need to add time filters also like the attached image.

Requirement is count of orders based on selections like date range i.e. satrtdate and enddate

and time range i.e. 8am to 10 am like that.

Please do the needful

Regards

Thiru

[sunny_talwar]

Try this

If(IsNull(GetFieldSelections(Starttime))=0 and isnull(GetFieldSelections(Endtime))=0,Count({<YearMonth={">=$(=Date(Vstartdate, 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(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(Vstartdate, 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(Venddate, 'YYYY/MM/DD h:mm:ss TT'))"}>} Country))

[#3]

Hi Sunny,

Thanks.It's working

Best Regards

Thiru