- 1. Zoho Deluge - Determine Quarter from Date with Fiscal Year
- / Zoho /
- What? This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal ...
- Created on 31 January 2020
- 2. Trim in T-SQL and SSIS
- / SQL Server Integration Services /
- ... equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE ...
- Created on 14 May 2013
- 3. MS Excel - Sort pivottable column headings by date
- / Excel /
- ... and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly Microsoft thinks Wednesdays come before Mondays... but what's wrong with this equation? You can tell me that ...
- Created on 12 April 2013
- 4. Difference between two dates - the midnight hour
- / Web-Development /
- ... as an example, the equation that's happening is: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession'])); $this_time_from1 = date("H:i", strtotime($sub_row['TimeFromSession'])); $this_time_to1 ...
- Created on 06 April 2011