Hi All, I have a column in database that shows DateCreated. Now I want to filter records depending on the date range selected. Eg, Created within 60 days, created withing year, etc. I have a variable dateCreated that shows me what the user has selected as the range.i.e., whether it is Created within 60 days, created withing year.

if (datecreated == "Created within 60 days")
                {
                    DateTime CurrTime = DateTime.Now;
                    if (prg.Subscriber.Username == CurrentUsername && prg.Program.DateCreated<=DateTime.Now - 60)
                    {
                        UserPrgList.Add(new ProgramSubscriptionViewModel(prg));
                    }
                }

But the above code wont work..what would be the syntax to get the records within a particular range??