how to calculate the date

[karthickkuchanur]

Hai,
I have the doubt that how to make query like
I have the start date and date
I suppose to calculate the the days from start date
for example if the date is25/02/2008.i have prepare the report for 13 days after the start date HOw can write the query for next 13 days

i use the Dateadd function but i cant able to phase the query

select startdate from ClientRegister between( DateAdd(day,13, startdate) from ClientRegister)
I tried like foolish sorry if it any wrong

[nedu]

Hi,

Please check this and let me know is t working r not . .


select startdate from ClientRegister where startdate between
startdate and ( DateAdd(day,13, startdate) from ClientRegister

Regards,
Nedu. M