Query to get all the terminated employees

[Nidhins27]

Hi,

Is there anyway to get the no. of employees terminated on a particular date or today if end date of the user in the user's table is empty.

Thanks

Nidhi Sharma

[nimitdave]

try if any of the below helps:

TERMDATE

UPDATEDATE

SAVUPDATEDATE

LASTSYNCDATE

[dgandhi]

Hi @Nidhins27 

Is there any property where you are storing/updating the term date or end date of the user?

If yes, then based on that property the query can be prepared.

Thanks

[rushikeshvartak]

Last 30 days 

SELECT USERNAME, FIRSTNAME, LASTNAME, EMAIL, OWNER, CASE STATUSKEY WHEN '0' THEN 'INACTIVE' WHEN '1' THEN 'ACTIVE' END AS USERSTATUS, UPDATEDATE as Updateddate, DEPARTMENTname as 'DEPARTMENT' FROM USERS WHERE UPDATEDATE > DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND STATUSKEY = 0;