Search results for query: *

sorry xlbo I thought I was in the right one. Will not post here again.

I can now get the formula to look at the date range and work for one cell. BUT if I drag the formula to the next cell the holiday data cell changes by one. ie .(E14,F14,GraphData!A2:A3) changes to(E14,F14,GraphData!A3:A4) I know there is something to fix the range but cant remember...

Hey its working! Thanks. I will now try and get the formula to look at a range so I can add the dates I need.

I have tried to do the following =IF(F14>0,10/24*(NETWORKDAYS(E14,F14)-2)+TIME(18,0,0)-(E14-INT(E14))+(F14-INT(F14)-(3/1/2005))-TIME(8,0,0),"Unresolved") What happens is that it takes the 8 hours off even when the holiday date is not withing the start and end times!

Thanks for replying MrMovie. I was wondering if the dates are held in part of the sheet or a text document. If they are how would I use them?

Hi All, I have the following formula in a spread sheet. It works out the total SLA hours in the week from start date to end date. =IF(F14>0,10/24*(NETWORKDAYS(E14,F14)-2)+TIME(18,0,0)-(E14-INT(E14))+(F14-INT(F14))-TIME(8,0,0),"Unresolved") This works well if the times are weekdays between 8...

Hey I done it ! but differently if {@Arrival date} in {@go back a week} to today then yellow else if {@Arrival date} in Over90Days then blue else white {go back a week} today - 7

Hi Madawc, Can't get my head around this one. I have looked in the manuals but it does not show this field. I do dayofweek (date -7) but get not enough arguments. I thought it would do the dayofweek is today - 7 therefore if I run it on thursday it should be last thursday is the start of...

Thanks Madawc, Will try this tomorrow.

I have sorted the dates into weeks but they are not thursday to wednesday. Do I have to make a formula that subtracts 3 from sundat to get thursday?

Hi all, This is exactly what I am working on at the moment. I have my report with Business Objects, they have been helping. What I have done so far is build the main report holding the data. Then make a sub report that uses shared fields on both the main and sub report. This "copies" the...

Hi, I need to show a graph which plots a week on week total of records opened. I am reporting from thursday to wednesday. But the end of week is friday. How do i group the records raised by thursday to wednesday? I know how to do the totals and charts. I just can't get my head around how...

Hi SQLBill. Been really busy, like all of us. This stuff is inside Crystal reports. It is a seperate section you can do extra sql while the report is running. Thanks for the tip about BOL. I will hunt someone down who has the CD as it's not running on this pc as it's on the server.I must...

SQLBill - Backend is SQL server this sql is inside Crystal reports. DBomrrsm Cant find that part to click on I am inside crystal reports sql expression builder I have been in a four hour meeting so could not get back sooner. Will have a go but it will be tomorrow as it's late here. I...

Hi again, First it said that there was a syntax error near select. That was the ( missing. Then when I fixed that it said that there was a syntax error near from, but did not say which from. I also took the red text out and put "ARSystem"."dbo"."AST_Asset" at the top (SELECT...

I think that Crystal reports puts the added SQL expression into the main SQL, looks like that anyway.

Sorry ! SELECT "AST_Asset"."Region", ((select distinct count("AST_Asset"."Asset_ID_") from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and ("AST_Asset"."Status" = '6' or "AST_Asset"."Status" = '0') ) ) FROM "ARSystem"."dbo"."AST_Asset" "AST_Asset" WHERE NOT...

Thanks for getting back DBomrrsm. I have put the following in (select distinct count("AST_Asset"."Asset_ID_") , "AST_Asset"."Region" from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and ("AST_Asset"."Status" = '6' or "AST_Asset"."Status" = '0') group by "AST_Asset"."Region") and get "Only...

Hi, This is the first time I have used the SQL forum. At the moment my SQL looks like this (select distinct count("AST_Asset"."Asset_ID_") from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and ("AST_Asset"."Status" = '6' or "AST_Asset"."Status" = '0') ) this gives me a figure of 1034. I...

Hi ro, and synapsevampire, thanks for replying. :0) I'm in England, depending on where you are replies may take time! I have put the following in with and with out quotes. (select distinct count("AST_Asset"."Asset_ID_") from AST_Asset where "AST_Asset"."Type" = 'ROUTER' and...