asked on

If select datename(dw,getdate(@SelectedDate)) is Sunday

@SelectedDate is an actual date like 04/26/2006

I don't know if I'm doing this line right
select datename(dw,getdate(@SelectedDate))
but

I want to say if select datename(dw,getdate(@SelectedDate)) is Sunday then
First = 1

if Monday then
First = 2

etc.

How do I do that?

****************************

IF @FreqID = 4
BEGIN
UPDATE SusansTable
SET
FreqID = @FreqID,
StartDate = 01/01/1900,
First = 2

WHERE SomeID = @SomeID
END

Aneesh

Hi net_susan,
IF @FreqID = 4
BEGIN
UPDATE SusansTable
SET
FreqID = @FreqID,
StartDate = 01/01/1900,
[First] = CASE datename(dw,getdate()) WHEN 'Sunday' then 1
WHEN 'Monday' then 2
WHEN 'Tuesday' then 3
WHEN 'Wednesday' then 4
WHEN 'Thursday' then 5
WHEN 'Friday' then 6
ELSE 7 End

WHERE SomeID = @SomeID
END

select datename(dw,getdate())

Aneesh R!

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MacNuttin

Here's some ideas:

DECLARE @DAY varchar(10), @SelectedDate datetime
SET @SelectedDate = getdate()
print @SelectedDate
SET @DAY = (select datename(dw,@SelectedDate))
print @Day
SET @DAY = (select datename(dd,@SelectedDate))
print @Day

net_susan

ASKER

Thank you!