Posts


[SOLVED] SQL Get Financial Year from Date

Published on February 07, 2018 at 12:21AM

This example will return the Financial Year for today's date. This can then be set to a variable to be used in another query

Using VS Code Extension MSSQL instead of Excel Power Query for Easy Database Querying

Published on February 07, 2018 at 12:01AM

Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.

Add Hyperlinks to an Entire Column using VBA in Excel

Published on February 05, 2018 at 04:50AM

Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query

[SOLVED] Excel VBA Get Financial Year from Date - No Formula

Published on January 23, 2018 at 01:42AM

Convert a date to the Financial Year (Fiscal Year) like '01/01/2017' = '2018'. Australian example used. Pure VBA without Excel formulas. Just the solution.

Create a Simple Empty Table in Power Query with Code Example

Published on December 14, 2017 at 06:23AM

Just copy and paste this into a blank query and you will get a simple two column table with two rows.

Add a Date Model to PowerBI or Power Query

Published on December 08, 2017 at 12:10AM

I regularly add a model to my Power BI or Power Query to represent the date and functions around date.

Tell MSYS2 Terminal to use existing .bashrc and .bash_profile from Git Bash

Published on November 15, 2017 at 02:57AM

You have been using something like Git Bash and now switch to MSYS2 but want to use your old .bashrc like before

Alias Database Table Column Names in trails.js using trailpack-sequelize

Published on October 29, 2017 at 11:58PM

You want a column to be called 'id' instead of 'TableID' because you don't have access to the database to rename the field directly

Connecting Ruby on Rails to an Existing SQL Server Database

Published on October 18, 2017 at 10:14AM

Notes I took when trying to connect a Ruby on Rails web app to an existing on premises Microsoft SQL Server Database

IFNIL formula in Excel

Published on August 30, 2017 at 07:00AM

Often you don't want to wrap an IF statement when you just want to turn a 0 result into another value such as blank