C# .NET - i have to write query to retrieve that records from database.

Asked By Priyanka on 12-Dec-12 01:58 AM
i have to write query to retrieve that records from database which have whatever previous date exists from todays date..

 like today is 12/12/2012.  and this query will check for previous date (12/11/2012). if it exists then fetch records... if it does not exist then it will check for (12/10/2012) and so on...

hope you understand my question..
Asked By Priyanka on 12-Dec-12 02:19 AM
but i think this query will fetch all the previous date records.. i have to only retreive records of one date that is previous from todays date..