hi,
Users can create an account on my site and I show all the users in a gridview including Account Created date.
I want to amend the SQL select query so that only accounts created from TODAY appear and nothing previously. So any accounts
created yesterday will not show in the gridiew. BUT tomorrow all accounts created today will still show and so on?
Here is my code?
SELECT ModelId, FirstName, LastName, OtherName, Email, Sex, CountryId, (SELECT CommonName FROM Country WHERE (CountryId = Model.CountryId)) AS CountryName, (SELECT UserName FROM aspnet_Users WHERE (UserId = Model.ModelId)) AS UserName, (SELECT
CreateDate FROM aspnet_Membership WHERE (UserId = Model.ModelId)) AS Created
FROM Model
WHERE Approved=0
ORDER BY CREATED DES ...
Go to the complete details ...