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]

Let you know what? Can you elaborate?

[#3]

Hi Sunny,

This is the condition i need to put in the report for time range,if you open my attached application then i have created that starttime and endtime .

Your application it is input box which end user has to enter the values.

But when i use the condition it is not working might be datatype issue.Please check and  do the needful.

[sunny_talwar]

May be this?

Count({<YearMonth={">=$(=Date(Vstartdate, 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(Venddate, 'YYYY/MM/DD h:mm:ss TT'))"}, Time = {"=Frac(Time) >= Starttime and Frac(Time) <= Endtime"}>} Country)

[#5]

Hi sunny,

try to give the range 6 am to 8 am It is not working for me.

only 8 to 11 is working.

Thiru

[sunny_talwar · Accepted solution]

This might be because of the rounding issue.... If you select 8:15, you should see two rows... or use this

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) >= Starttime and (Frac(Time) - 1/86400) <= Endtime"}>} Country)

[#7]

Hi sunny,

I guess it is working.

and here mandotory we need to select both date and time.but for me two cases are requiered.

1.only date

2.date and time

so can i use

if(GetFieldSelections(Starttime,1,

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) >= Starttime and (Frac(Time) - 1/86400) <= Endtime"}>} Country),

Count({<YearMonth={">=$(=Date(Vstartdate, 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(Venddate, 'YYYY/MM/DD h:mm:ss TT'))"}>} Country)))

Regards

Thiru

[sunny_talwar]

Sure... give it a try

[#9]

Hi Sunny,

I have chnged Starttime and endtime which are in link tab

from 01:00:00 AM to 1:00 AM

          02:00:00 AM   to 2:00 AM like that

then it is not working.Please so the needful

Regards

Thiru

[sunny_talwar]

Please do the needful by sharing a sample and pointing out what the issue is within your sample

[#11]

Hi Sunny,

My apologies for not giving complete information.

Issue is As of now we are using StartTime and Endtime variables which are coming from inline data prseneted in link tab in the script format is

02:30:00 AM,

  02:45:00 AM,

   03:00:00 AM,

   03:15:00 AM,

03:45:00 AM,

   04:00:00 AM,

   04:15:00 AM   like that

here my Time column also loading using time(tempdate) as Time

so our expression is

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) >= Starttime and (Frac(Time) - 1/86400) <= Endtime"}>} Country),

Count({<YearMonth={">=$(=Date(Vstartdate, 'YYYY/MM/DD h:mm:ss TT'))<=$(=Date(Venddate, 'YYYY/MM/DD h:mm:ss TT'))"}>} Country))

is working fine.

Now the issue is i have changed the  Starttime and Endtiem format in link tab change s to

12:00 AM,

    12:15 AM,

    12:30 AM,

    12:45 AM,

     1:00 AM,

     1:15 AM,

     1:30 AM,

     1:45 AM,

     2:00 AM,

     2:15 AM,

     2:30 AM like this

after chnageing this format it is not working.

Please do the needful in changing the syntax according to the time format.

Regards

Thiru