anyone can advise how I can check when is the last date the user change the password?
Nothing free here. The encrypted file that controls Sage passwords is not in a database, you can't query it with SQL.
The password is definitely encrypted.
By the way, I am not looking for password-related info but the last password change date. Does this information stored somewhere in the database?
It's not in a database.
As mentioned above, nothing is free. Check out the functionality and features of Tairox SOX User Management, a very affordable tool, quite beneficial especially when having to manage a lot of users in many entities. The reporting is quite comprehensive. And, if the environment in question has allows passwords to expire (Sage authentication) then you can report on that. Would not work when using Windows authentication but you wouldn't need to track that in Sage anyway. https://www.tairox.com/sox-user-management-for-sage-300-erp-accpac.html
*Community Hub is the new name for Sage City