i have date filed stored as nvarchar in sql server=
joindate=20/10/2008
relivingdate=
i want to retive reliving date from joining date
employee joining date is as below20th of October 2008
ex
if joining date is 20/10/2008 reliving date should be 19/10/2009 i.e one day before one year
i want sql qurey to retrive the reliving date...
or vb code..