CASE 
WHEN ENTITY + ACCOUNT LIKE 'ENT_1010ACC_1560020' THEN 'ACC_1560000' 
WHEN ENTITY + ACCOUNT LIKE 'ENT_1010ACC_1560100' THEN 'ACC_1560000' 
WHEN ENTITY + ACCOUNT LIKE 'ENT_1010ACC_1560300' THEN 'ACC_1560000' 
WHEN ENTITY...

Again many thanks for all your help.  this was the final solution

CONVERT(CHAR(10), Dateadd(dd,-1, Dateadd(mm,1,PeriodID + DateName(yy,Getdate()))), 101) AS PeriodEndDate

got it thanks

ok thanks for all the posts.  First this is a view, and I now know declare statements do not work in a view

so I updated the statement to this, but...

thanks for all the posts.  I have it now, and it works great.  I really appreciate all of you posting these options.  As you can  tell I am not a...

never mind got it. thanks

When 'Jan' THEN Dateadd(Day, -1, Dateadd(Month, 1, @jan01))

I think the first solution is the best for me in the instance.  As it would account for year and leap year changes.  but I keep getting an error  message

The...

however if I just concatenate the year, then every 4 years I need to update for the leap year affect.

yes as you were posting I was searching the internet and found the year function.  I did not do the CHAR(4) as you did so your solution worked.

So I tried the date function

Dateadd(Day, -1, Dateadd(Month, 1, @jan01), 0)

and I get an error message

The DateAdd function requires 3 arguments.

I will look into SQL prompt this week, thanks

great question about why I changed the value.  and the future effect on audit.  we are in fact a sox compliant company, so great question

first this was on...

thank you so much for taking the time to clean up my code.  I appreciate your time.  this is a big help to me.

ok so this is the correct code?

INSERT