How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 the following MDX statement which had seconds as its smallest denominator: ="Execution Time: " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours) + " hour(s)" + " , " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes) + "...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 } // // calculate Eastern time (System HQ) if(!isnull(input.GMT_Date_Time_Start)) { // subtract 5 hours from GMT as system is based in US/Eastern time input.System_Date_Time_Start = input.GMT_Date_Time_Start.subHour(5); input.System_Date_Time_End =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const VK_NUMPAD8 = $68 Const VK_NUMPAD9 = $69 Const VK_MULTIPLY = $6A Const VK_ADD = $6B Const VK_SEPARATOR = $6C Const VK_SUBTRACT = $6D Const VK_DECIMAL = $6E Const VK_DIVIDE = $6F Const VK_ATTN = $F6 Const VK_CRSEL = $F7 Const VK_EXSEL = $F8 Const...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Note how I'm simply adding 7 to the start of the week date (subtract 1 so this is not inclusive). Crude solution but it works in Excel 2007 Now we want to filter the pivotTable data based on these two values... (I don't like the idea of requiring macros...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 getdate())) Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms, seconds * 1000, 0), 114) Add/Subtract Date DATE_ADD(date,INTERVAL number datepart) DATE_SUB(date,INTERVAL number datepart) DATEADD(datepart, number, date) DATESUB(datepart,...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 yyyy-MM-dd Due_Date in this example is at the end of the current month: so add 1 month, go to the start of that month, subtract 1 day. .toEndOfMonth() used to work but appears to be deprecated. Invoice_Ref_ID is excluded from being copied as it was an...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

11 November 2021 Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want to add 10 minutes to a date/time field in ZohoCRM and wanted a refresher for use in a client system....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 and so on... How? The logic behind this would be to take the date of the order, check if the order date is a Sunday, subtract a day, and return the week number: c_Order = Order[ID == 123456890123456890]; if(c_Order.Order_Date != null) { v_ThisDate =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MySQL Transactions in PHPhttps://www.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB