how can i find out next three dates greater than a given dates with a sane occourance of day in sql

Question

0.00/5 (No votes)

See more:

how can i find out next three dates greater than a given dates but condition is that the day occourance is same for all these three days , actually i am selecting day name from my table
and i want to get these three dates by calculation (these dates are not in my table )

alter procedure Select_Disurbment_Dates

as
begin
(
@Dayname varchar(300)

)
declare @max_Id int,@previousDate datetime,@current_system_date datetime,@FirstDate datetime, @Min_disburment_date datetime
set @max_Id=(select MAX(dayopencloseid) from DayOpenDayCloseInfo
where CollectionByLoanOfficerStatus=1 and DayCloseByAdminStatus=1 )

set @previousDate=(select CenterCollectionDate from DayOpenDayCloseInfo where dayopencloseid=@max_Id)

set @current_system_date=(Select DATEADD(d,1, @previousDate) as Current_SystemDate )
--set @FirstDate=(Select DATEADD(d,7, @current_system_date) )
set @Min_disburment_date=(Select DATEADD(d,14, @current_system_date) )

end

for example .. ..

date that i got through procedure(i.e. @Min_disburment_date) is 15/08/2013
and my procedure parameter (i.e. @Dayname ) value is 'Saturday' . so i want to select next three dates of 15/08/2013 which has day 'Saturday' and the resulted dates are ...

17/08/2013
24/08/2013
31/08/2013

both these dates have saturday

pls suggest .. i am tired to do this ... :)

Posted 16-Aug-13 19:39pm

GDdixit

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dineshshp · Accepted Answer · 2013-08-16T19:58:00

Try this...

SQL

declare @Dayname varchar(25)
declare @Min_disburment_date datetime
set @Dayname = 'Saturday'
set @Min_disburment_date = '15-Aug-2013'

select @Dayname, @Min_disburment_date, DateName(weekday,@Min_disburment_date)

WHILE DateName(weekday,@Min_disburment_date) <> @Dayname
	BEGIN
		SET @Min_disburment_date = dateAdd(d,1,@Min_disburment_date)
	END

select @Dayname, @Min_disburment_date, dateAdd(d,7,@Min_disburment_date), dateAdd(d,14,@Min_disburment_date)