ASP.NET

declare @date as varchar(15) <br />
set @date = '2008-04-15' //here u give input parameter<br />
select  * from myTable  where Datetime >= convert(varchar(15),cast(@date as datetime),102)<br />
and datetime<=  convert(varchar(15),(cast(@date as datetime)-365*2),102)

qs_Start<br />
2008-04-16<br />
2008-04-15<br />
2008-04-14<br />
2008-04-13

qs_Start<br />
2008.04.16<br />
2008.04.15<br />
2008.04.14<br />
2008.04.13

declare @date as varchar(15)<br />
set @date = '2008-04-16'<br />
select * from tbl_QualityStandard where qs_Start >= convert(varchar(15),cast(@date as datetime),103)<br />
and qs_Start <= convert(varchar(15),(cast(@date as datetime)-365*2),103) 

Dot Net rookie wrote:

My file looks something like this:

Private Sub ChangeXMLValue(ByVal XMLPath As String, ByVal NewValue As String)<br />
        ' Load XML<br />
        Dim xmlDoc As New Xml.XmlDocument<br />
        xmlDoc.Load(XMLPath)<br />
<br />
        ' Find node<br />
        Dim xmlNodes As Xml.XmlNodeList = xmlDoc.GetElementsByTagName("[Name Of the Tag which contains 'some text 1']")<br />
        If xmlNodes.Count > 0 Then ' Found it<br />
            ' Replace value <br />
            xmlNodes(0).Value = NewValue<br />
        End If<br />
<br />
        ' Replace XML <br />
        System.IO.File.Delete(XMLPath)<br />
        xmlDoc.Save(XMLPath)<br />
    End Sub