Jennifer Fink
- Total activity 35
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 7
- Subscriptions 12
Comments
Recent activity by 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.
-
Hi Geoff. That worked. Thank you very much!
-
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...
-
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...
-
That was it exactly. Thank you very much for your help.