T-SQL – How to output day number from date
The following T-SQL statement shows how output the day from a date. For example, 16 March 2019 would output 16. SELECT DateName( day, GETDATE() ) as Day_From_Date
Date
T-SQL – How to output name of month
The following T-SQL statement shows how output the name of the month from a date. For example, 16 March 2019 would output March. SELECT DateName( month , GETDATE() ) as…
T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH
The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th). For example, 16 March 2019 would output 16th. How do…
Excel – How to calculate the difference between two dates
The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months years days - ignoring years days - ignoring months and…
How to hide the admin toolbar
Logged in users will see a toolbar at the top of the page - for both the wp-admin and front end pages. You can hide the admin toolbar for front…
How to create a WordPress plugin for your custom functions
When you need to run custom PHP code on your WordPress site often you're instructed to add it to the active theme’s functions.php file. The issue with this is that…
How to install WordPress beta versions
The following steps show up to install future release versions of WordPress. This is usually done for testing purposes and should never be done on a production WordPress site. If you…
How to set email sender address using from address
When sending emails meta-data in the email "header" explains who sent the email. There are two similar, but quite different, details that when not set correctly can make your emails…
How to add text/plain to HTML emails
By default WordPress will send emails as plain text using the content type "text/plain". But some plugins, such as Gravity Forms, will send HTML emails. The issue with this is…