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…
YEAR
SQL – How to select current year from lookup table
This SQL query demonstrates how to retrieve the ID of the current year from a lookup table by utilizing the current date with GETDATE(), converting it to a year number…
SQL – How to get current financial year using SQL
Learn how to retrieve the current financial year in SQL with this simple and effective solution, assuming the fiscal year starts on July 1st and ends on June 30th. Get…
SQL – How to select current financial year from lookup table
This SQL query demonstrates how to retrieve the current financial year from a lookup table by utilizing the current date, month, year, and cast functions. It returns the selected row…
[SOLVED] Crystal Reports – ‘A month number must be between 1 and 12’ error
The article provides a solution for the 'A month number must be between 1 and 12' error in Crystal Reports while calculating previous month using formulas. It suggests using DateSerial…
Is CloudFlare Pro worth getting?
Is CloudFlare Pro worth the investment? Read our review to find out
[SOLVED] Crystal Reports – Prompting failed error message
How to fix the "Prompting failed" error message in Crystal Reports when running a report. The solution involves checking for unassigned dynamic parameters, changing them to static, or assigning a…
How to set default SELECT OPTION using jQuery/JavaScript
This article provides a solution for setting a default SELECT option using jQuery/JavaScript, including how to target specific forms and select options based on different criteria such as the current…
How to echo month name using DOS CMD Catch file
This DOS script outputs the current month's name by parsing the system's local datetime and uses conditional statements to assign the appropriate month name based on the value obtained. It…