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…
Text of dates in Crystal Reports can be annoying - you can't apply any date-specific formatting or use the date in formulas - because it is after all, just the…
The following code shows how to calculate the financial year from a date in a Crystal Reports. It uses the Australian financial year which is from July to June, e.g.…