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…

Change the delimiter character in Excel 2013/2016 to use a pipe character instead of a comma for saved CSV files by modifying the system's regional settings in the Windows Control…

​Learn how to split comma separated values from one column into multiple columns using Excel 2013/2016 with this step-by-step guide. Perfect for transforming messy data into organized information.

Learn how to convert a date to its corresponding day of the week using formulas in Crystal Reports with our step-by-step guide featuring the DayOfWeek and WeekdayName functions.\*Please include one…

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…

​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…

Convert numbers to text in Crystal Reports without formatting using the "toText" function with a formula that displays the number as part of a string.Meta Description: Learn how to remove…

​Learn how to format a decimal value in SQL Server with this example showing how to convert a decimal value like 1234567.89 into a space-delimited currency, such as $ 1…

​How to display a NULL value as a zero in Crystal Reports? Learn two ways to achieve this by following our step-by-step guide.