Thanks Lynn..

Just another reason to format !!! 🙂

I get Incorrect syntax near ')'.

But can't find it?

here is everything

O

/****** Object: StoredProcedure [dbo].[jb_test_deleteme_sp] Script Date: 03/27/2013 14:18:42 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[jb_test_deleteme_sp]

(

@StartDate datetime,@EndDate...

Parameters are for FY

I want a client count for each month

Hi Lynn,

I came up with his but I think it's kind of a crappy way to do it...

I have a case for each month

CASE WHEN DATEPART(mm,STARTTIME) = 1 THEN...

Sorry.. I had 1july and should have been 1July, didn't know it was case sensitive

Thanks

That works great..

I even understand it!! 🙂

Thanks Again

Scott

Thanks for the info

I should hav explained more and now that I see what you sent,

When I run

SELECT Date, Year, CASE DATEPART(mm, date)...

Sorry....

I missed a field that was placed a few lines below I didn't see....

I was missing the comma, it works now

Thanks

Joe

WHEN 07 THEN (APPT_RPT_APPOINTMENT.DURATION / 60) END AS Julyschedhours ...

Hi

I just did

SET datefull = dateadd(ms,-3,cast((dateadd(d,1,cast(datefull as DATE)) )as datetime))

worked great

Thanks for all the help

Now I just have to read up on what it all does 🙂

Thanks Jeff for getting back

I've kind of changed direction a bit

I'm new at SSRS, and I wanted to use the date table to display only Friday dates,

but I...

Thanks Sean

Great Idea, someone exlse mentioned the simple math problem, now I understand

Thanks Abu really appreciate it, I really have to stop thinking crystal syntax!!

Yes sorry...

The report has 4 formulas this is one of the four (same except for the date ranges)

sp has one parameter for a date

First part calculated which date to use...

WORKS!!

Thanks so much

these both work great, but I get Must declare the scalar variable "@fiscalstart". in my where

I wont scare u with the horrid code between... 🙂

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE...