@frederico I am sorry I don't have documentation for the table.

If you want that's the code.

,WF_SMP AS (
--FILTERED TO 4 WEEKS ONLY(!)     ...

Thank you for your initial reply. I casted to CHAR. It fixed itself.

Thanks.

• This reply was modified 2 years, 4 months ago by  JeremyU.

Jeff, thank you but I am getting the very same error when using this query

DATENAME(dw,DATEADD(dd,DATEDIFF(dd,6,S1SDAT)/7*7+6,6))

Arithmetic overflow error converting expression to data type datetime.

I am really sorry but I don't think I am allowed to install that in  my database. Maybe there is a different way...

If it is Saturday 07/30 for example, I want it to be 7/30.

7/31 should be 08/06.

Scott

I am getting an error "Arithmetic overflow error converting expression to data type datetime."

Johan Bijnens it appeared to be in float as I understand, not sure why.

frederico_fonseca

Thank you very much. It fixed my issue. I appreciate it.

Pietlinden thank you. I am getting an error "Operand type clash: date is incompatible with float".

Hello everyone,

When running on a big dataset I start getting an error "Conversion failed when converting date and/or time from character string."

• This reply was modified 2 years, 8 months ago by  JeremyU.
• This reply was modified 2 years, 8 months ago by  JeremyU.

Hello

Can the admin just delete this post?

I figured we just need to put "> ="  and f.[STARTDATE] > = u.[STARTDATE]

@desnorton thank you. The only thing it find the last Sunday (1/09) I need to find the Sunday prior, namely 1/02. Do you know what I need to...

@pietlinden thank you.  I am really sorry for taking your time. It is pretty complex for me to  figure out how to use it in my query. In...

When "Issue" IN ('Overforecasted', 'Underforecasted' AND there are 3 different dates in column "Start Date" (can be more than 3 weeks but should be at least 3 different dates) return...

I basically need to write a SQL code for such a statement.

I know this is not a proper SQL statement, but I am trying to understand how it can be...