Hi I am trying to do a calculation of the number of helpdesk calls that are open at the end of the day.
I am using the following
sum(if(FROM_UNIXTIME(maindb.closedatex,"%Y-%m-%d") > dates.date,1,0 ))
This checks if the close date of the call is greater than my date field. However if a call is still open then the closdate is displayed as "1970-01-01"
Does anyone know how I can add this into the statement above?