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…
Date field
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…