T-SQL – How to output day number from date
Learn how to extract the day number from a date using T-SQL with this simple and effective code snippet. Get the day number for any given date in SQL Server.
Date
T-SQL – How to output name of month
This T-SQL code demonstrates how to display the name of the current month using the DATENAME function in SQL Server.
T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH
This T-SQL statement demonstrates how to output the day from a date in ordinal numbers using SQL Server. Learn how to replace `Getdate()` with your date field and format the…
Excel – How to calculate the difference between two dates
Learn how to calculate the difference between two dates in Excel using the DATEDIF formula with different units such as days, months, years, days-ignoring years, days-ignoring months and years, months-ignoring…
How to set email sender address using from address
Learn how to set email sender and from address in WordPress to avoid having your emails marked as spam by spam filters. This guide provides a solution using a custom…
How to add text/plain to HTML emails
How to add plain text to HTML emails? Learn how to automatically add the plain text content from your HTML email using a simple WordPress plugin. Prevent spam filters and ensure delivery
Crystal Reports – How to convert text date to datetime format
Convert text date to datetime format in Crystal Reports with these two methods - DateValue and cDate. Learn how to convert text date fields into usable date fields for better…
Crystal Reports – How to calculate financial year from date
Learn how to easily calculate the financial year from a date in Crystal Reports using this simple formula. This code works for the Australian financial year starting from July to…
Excel 2016 – How to calculate age from date of birth
How to calculate age from date of birth using Excel 2016? Learn how to use INT and IF functions to find out your current age or the age of someone…