Crystal Reports – How to calculate financial year from date
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.…
Financial year
SQL – How to get current financial year using SQL
The following SQL shows how to get the current financial year using SQL. This assumes that the financial year for your country is 1 July - 30 June. This SQL…
SQL – How to select current financial year from lookup table
The following SQL shows how to select a row from a table using the current financial year as the WHERE condition. This is useful if you have a table of…
How to set default SELECT OPTION using jQuery/JavaScript
I recently needed to set a default option for a SELECT drop down list. As you probably already know, select elements do not support a default value, but you can…