Is there a way to sort the users by their joining date? So that I can see who is the oldest user and also who is the latest user.
Here you go using Data.SE
SELECT TOP ##Top## ID AS [User Link], Reputation
, CreationDate, LastAccessDate, Location
ORDER BY CreationDate
For the latest users just order the records in descending order instead of ascending order.
ORDER BY CreationDate DESC
Note that data in Data.SE is updated weekly So the latest users will be at least one week old. However it won't affect the oldest users :)
AFAIK, such feature is not available for normal users. May be data.stackexchange.com help you to finding users by joining date.
Each user has given a unique user Id, based on this Id you can differentiate between two or more users that which user has joined site first.