Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
101 Points
56 Posts
Apr 19, 2012 06:05 AM|LINK
SQLQUERY
SELECT *
FROM
YOURTABLENAME
WHERE
YOURDBDATE between convert(datetime,YOURFROMDATE , 105) and convert(datetime, YOURTODATE, 105)
ORDER BY DBFIELD ---FOR SORTING BY ASCENDING OR DESCENDING
prashantdigh...
Member
101 Points
56 Posts
Re: Sort result from given period of time using Calendar.
Apr 19, 2012 06:05 AM|LINK
SQLQUERY
SELECT *
FROM
YOURTABLENAME
WHERE
YOURDBDATE between convert(datetime,YOURFROMDATE , 105) and convert(datetime, YOURTODATE, 105)
ORDER BY DBFIELD ---FOR SORTING BY ASCENDING OR DESCENDING