I appreciate any help, you experts are great...
I"m building a monthly report that will list the amount of accounts an individual has worked each day. The fields I am using are AccountNum, StartTime(DateTime) and EndTime(datetime) I'm able to pull data by the correct day of the month looking at the day part of the datetime field. and writing a formula like the one below for each day 1-31.
-------------------------------------------------------
If Day({PROCESSLOG.ENDTIME})=1
then 1
-------------------------------------------------------
My problem is that on Monday-Thursday we only want to count accounts that were worked between 8:15 PROCESSLOG.STARTTIME & 5:30 PROCESSLOG.ENDTIME. And on Friday 8:15 PROCESSLOG.STARTTIME & 6:00 PROCESSLOG.ENDTIME.
I put together a formula below, but I can't get it to work. I'm using CR8..
If Day({PROCESSLOG.ENDTIME})=1 and DayOfWeek({PROCESSLOG.ENDTIME}) in [1,2,3,4] and
Time({PROCESSLOG.STARTTIME})>=08:15:00 and Time({PROCESSLOG.ENDTIME})<=17:30:00
then 1
If Day({PROCESSLOG.ENDTIME})=1 and DayOfWeek({PROCESSLOG.ENDTIME}) in [5] and
Time({PROCESSLOG.STARTTIME})>=08:15:00 and Time({PROCESSLOG.ENDTIME})<=18:00:00
then 1
Thanks
I"m building a monthly report that will list the amount of accounts an individual has worked each day. The fields I am using are AccountNum, StartTime(DateTime) and EndTime(datetime) I'm able to pull data by the correct day of the month looking at the day part of the datetime field. and writing a formula like the one below for each day 1-31.
-------------------------------------------------------
If Day({PROCESSLOG.ENDTIME})=1
then 1
-------------------------------------------------------
My problem is that on Monday-Thursday we only want to count accounts that were worked between 8:15 PROCESSLOG.STARTTIME & 5:30 PROCESSLOG.ENDTIME. And on Friday 8:15 PROCESSLOG.STARTTIME & 6:00 PROCESSLOG.ENDTIME.
I put together a formula below, but I can't get it to work. I'm using CR8..
If Day({PROCESSLOG.ENDTIME})=1 and DayOfWeek({PROCESSLOG.ENDTIME}) in [1,2,3,4] and
Time({PROCESSLOG.STARTTIME})>=08:15:00 and Time({PROCESSLOG.ENDTIME})<=17:30:00
then 1
If Day({PROCESSLOG.ENDTIME})=1 and DayOfWeek({PROCESSLOG.ENDTIME}) in [5] and
Time({PROCESSLOG.STARTTIME})>=08:15:00 and Time({PROCESSLOG.ENDTIME})<=18:00:00
then 1
Thanks