how to add 2 dates that are in string format to get the next date

[agz86]

hi all.i have 2 dates in string format.i need to add these 2 dates to get the next date. is there any sql query for this?? Plz sum1 help me. urgent!! Thanx in advance...

[dickersonka]

you posted this in the asp forum, but you are asking for sql

how are you wanting to add dates?
you can add dates together, but i don't really know what good that would do for you

be more clear on what you want

if you want to just add days lets say

dateadd(d,1,getdate())

[udaybhoite]

hi guys

First convert both string into date format
then two dates can be add in vb.net using function.
So for in ASp.net forum u need to right customised function.
Same in SQL for Ms SQL SERVER using procedure u can convert strings to a date format
and then using datediff & dateadd function user can add to diff. dates are in string format