judy pritz
asked on
Creating Peak and Off Peak Timebands
I have written a formula to split peak from off peak time, peak is only Monday to Friday, the result is only returning data for off peak, please see formula below;
If ( (time({STAT_RM_TRANSACTION S.TRIPDATE TIME})>=ti mevalue(03 ,00,00) AND time({STAT_RM_TRANSACTIONS .TRIPDATET IME})<=tim evalue(09, 29,59))
AND (
(time({STAT_RM_TRANSACTION S.TRIPDATE TIME})>=ti mevalue(15 ,30,00) AND time({STAT_RM_TRANSACTIONS .TRIPDATET IME})<=tim evalue(17, 59,59))
) AND
datepart("w",{STAT_RM_TRAN SACTIONS.T RIPDATETIM E}) IN [2,3,4,5,6] //weekdays
) THEN "Peak"
ELSE "Off Peak"
If ( (time({STAT_RM_TRANSACTION
AND (
(time({STAT_RM_TRANSACTION
) AND
datepart("w",{STAT_RM_TRAN
) THEN "Peak"
ELSE "Off Peak"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Logic problems are always the hardest to find. Have a great day.
logic error fixed
ASKER