Hello All,
I have the following data in a table:
Hours DOW
====== ====
2307 Wednesday
Group CreatedDate
===== ===========
<GroupName> 2003-01-01 23:07:54.000
As you can see the Hours column is nothing but the Time in 24-hr format got from the Actuate function Format$(Date,"hhnn".
Now I want to create a report by each DOW like Monday,Tuesday,Wednesday and so on by each hour of the day. Say I want the total count on Wednesday between 0000-0059 and so on for each hour of the day till 2300-2359. I have a text value which has the following in the Expression Builder:
Count( ) Where( Hours >= "0000" And Hours <= "0059" And DOW Like "Monday%" )
This returns me a 0 value but if I do a count in SQL like this:
Select count(*) from DayWiseCalls where hours >= '0000' and hours <= '0059'
and DOW like 'Wednesday'
it returns me a value of 52
What am I doing wrong and what can I do to rectify this?
TIA
I have the following data in a table:
Hours DOW
====== ====
2307 Wednesday
Group CreatedDate
===== ===========
<GroupName> 2003-01-01 23:07:54.000
As you can see the Hours column is nothing but the Time in 24-hr format got from the Actuate function Format$(Date,"hhnn".
Now I want to create a report by each DOW like Monday,Tuesday,Wednesday and so on by each hour of the day. Say I want the total count on Wednesday between 0000-0059 and so on for each hour of the day till 2300-2359. I have a text value which has the following in the Expression Builder:
Count( ) Where( Hours >= "0000" And Hours <= "0059" And DOW Like "Monday%" )
This returns me a 0 value but if I do a count in SQL like this:
Select count(*) from DayWiseCalls where hours >= '0000' and hours <= '0059'
and DOW like 'Wednesday'
it returns me a value of 52
What am I doing wrong and what can I do to rectify this?
TIA