Jennifer Fink

I was able to solve this issue. Changed FORMAT(1700, '##:##') to FORMAT(1700, '00:00'). I haven't researched why this matters yet but will do so soon.

• Ver comentario
• 4 de junio de 2025 13:57
• 0 votos

Hi Geoff. That worked. Thank you very much!

• Ver comentario
• 6 de octubre de 2023 13:18
• 0 votos

Hi Geoff. Thank you very much for the quick response. I've gotten it to work. A little bit of operator error in that I my abbreviated query I posted neglected to include the field OSCL.itemCode. Yo...

• Ver comentario
• 4 de agosto de 2023 17:55
• 0 votos

Hi Geoff. Certainly. SELECT CRD1.State AS 'State',ISNULL(OSCL.queue,OSCS.Name) AS Queue, OSCL.CustmrName AS 'Customer', OSCL.DocNum AS 'ServiceCallNumber', OSCL.createDate AS 'Create Date', OSCL.cr...

• Ver comentario
• 4 de agosto de 2023 17:09
• 0 votos

That was it exactly. Thank you very much for your help.

• Ver comentario
• 27 de abril de 2023 21:09
• 0 votos