Custom report of requesters plus custom field
I have this query:
SELECT aau.FIRST_NAME "Requester", LONGTODATE(reqf.UDF_DATE1) "Mobile Phone Upgrade Date" FROM AaaUser aau LEFT JOIN Requester_Fields reqf ON aau.USER_ID=reqf.USERID WHERE ((reqf.UDF_DATE1 < 1307592000000) AND (((reqf.UDF_DATE1 != 0) AND (reqf.UDF_DATE1 IS NOT NULL)) AND (reqf.UDF_DATE1 != -1)))
It works, but I would like to set the WHERE reqf.UDF_DATE1 < 1307592000000 to the current date so I don't have to manually specify a date. I'm using MySQL as the database.
I'm essentially generating a report that tells me which users are eligible for a mobile phone upgrade based on the reqf.UDF_DATE1 field. I tried using WHERE reqf.UDF_DATE1 < unix_timestamp(now()), but that gives me no results--no error, but no results. Thanks!
SELECT aau.FIRST_NAME "Requester", LONGTODATE(reqf.UDF_DATE1) "Mobile Phone Upgrade Date" FROM AaaUser aau LEFT JOIN Requester_Fields reqf ON aau.USER_ID=reqf.USERID WHERE ((reqf.UDF_DATE1 < 1307592000000) AND (((reqf.UDF_DATE1 != 0) AND (reqf.UDF_DATE1 IS NOT NULL)) AND (reqf.UDF_DATE1 != -1)))
It works, but I would like to set the WHERE reqf.UDF_DATE1 < 1307592000000 to the current date so I don't have to manually specify a date. I'm using MySQL as the database.
I'm essentially generating a report that tells me which users are eligible for a mobile phone upgrade based on the reqf.UDF_DATE1 field. I tried using WHERE reqf.UDF_DATE1 < unix_timestamp(now()), but that gives me no results--no error, but no results. Thanks!