Hi,

I would like to generate login hours report but only per today or from yesterday to today, not per month. I have try to modify the query AND ( acs.OPENTIME IS NULL OR acs.OPENTIME > < from_yesterday > - < to_today > ) but the generated report still showing per month. anyone can assist me give the correct query would be much appreciate.