Recent content by madonnac

using MD5 will give you less chance of a collision (or, any of MD2 | MD4 | MD5 | SHA | SHA1 | SHA2_256 | SHA2_512 ) the hashbytes function takes an algorithm, and a single variable. e.g. select hashbytes('MD5','madonnac') : 0xD7CA39B7F7F21CB229DC3DA72E17C064 select hashbytes('MD5','COOK...

slice the string up. Case will recognize date format #107 (mmm dd, yyyy), which is only slightly different to your format declare @d varchar(40) set @d = 'Mar-01-2016' select cast(left(@d,3)+' '+substring(@d,5,2)+', '+substring(@d,8,4) as datetime2) You should be able to use things like...

Chris, Add a /D to that, and it will also handle directories: ATTRIB -R *.* /S /D

VLOOKUP will also work for this =A1 & " " & IFERROR(VLOOKUP(A1,Sheet1!$A$1:$C$55,3,False),"is NOT on the Table")

Unfortunately, I only have 2010 and 2013 to check this, but there should be a proofing option, where you have an Autocorrect section. This should allow you to disable the autoformat of name and email address. As to the name/email fixing, this horrible looking formula will try to fix the data...

ISERROR is an optimized version of IF(ISERROR( Cell(2) Cell J49 =K49/I49 would become Cell(2) Cell J49 =IFERROR(K49/I49,"") Note that this will trap all errors, so things like #VALUE! , #NA! and #ERR! will also be caught

I am running CMS Supervisor V 16.2.KC.12 If I select manual login, I can log into the servers with no issue. If I uncheck that box, it just sits at "Initializing, and does not get any further. One server is R16.2, the other is R14. Both show the default terminal as cvsup on the manual login...

With this code to run a stored procedure: Set cmdl = New ADODB.Command With cmdl .ActiveConnection = StrCon ' Connection to the Database 'set COMMAND timeout property - query can time out on either the connection OR the command .CommandTimeout = 0 .CommandText = "spCrossTabRun"...

Try connecting to \\OtherCompterName\c$ - the c$ is an admin share, which will require the Admin user/pass for that computer. Note that the admin password has to exist - a blank password will refuse connections from other computers using that name e.g. UN:AdminBlank, Password:<none> -...

Index: use of the 0: If you set row_num or column_num to 0 (zero), INDEX returns the array of values for the entire column or row, respectively. or If you set row_num or column_num to 0 (zero), INDEX returns the reference for the entire column or row, respectively There is nothing wrong with...

To sum a 3-D array, we need to use an array formula First, the easy part - The Section: (A2:A4="A") This will give us true or false for each row. Then we work down the rows, and see if the date is correct: IF(B1:D1<TODAY(),B2:D4) We multiply each row by the true/false from the section, which...

The easiest way is with an IFBLANK test. =IF(ISBLANK(YourCellFormula),"",YourCellFormula)

you may need to adjust the vbLf constant, depending on the values that force the new line vbLf is the LineFeed character, chr(10) vbCR is the Carrage Return character, chr(13) vbCrLf is both combined into one These selections cover 95% of the cases. Create a UDF function: Function...

yes, and I can edit both reports to show the other calculation, which shows the discrepancies.

I have 2 reports (designed by different people) that use 2 separate calculations to work out total call time (without ACW) One uses ACDTIME + HOLDTIME The other uses i_acdtime + i_acdothertime + i_acdaux_outtime Looking at the definitions in the Avaya help file, they would seem to be...