how to check this date is 6 months or 1 year for given condition

[developerit]

hi, iam using asp.net with c# with sql server databae the table fields are username nvarchar startdate datetime enddate datetime paytype int reminder int while registering the user will selects the startdate and enddate and the pay type is 6months or 1year and he will select the reminder before 10days then if he selects for 6months then before 10days i have to send email. if he selects for 1year i have to send for every 6months before 10 days then how to write the querry for this condition please give the example which helps me.

[Lost User]

developerit wrote:

then how to write the querry for this condition please give the example which helps me.

You'll need to write a SELECT[^] statement, with a filter on the EndDate. You'd have to compare whether this EndDate equals "today" + 10 days. You can get todays date by using the GETDATE()[^]-function, and add 10 days using the DATEADD[^] function. Good luck :)

I are Troll :suss: