This is what I created and it works just wondering if anyone has anything
else
declare @friday smalldatetime
set @friday = getdate()
Create_Friday:
while (datepart(dw,@friday)) <> '6'
begin
set @friday = dateadd(d,1,@friday)
end
if(datepart(dw,@friday)) <> '6'
begin
goto Create_Friday
end
else
begin
select @friday
end
-----Original Message-----
From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 8:01 AM
To: CF-Talk
Subject: Sql Statement
Can anyone help me with a quick SQL statement to give me Fridays date of the
current week?
Thanks,
Joshua Tipton
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
