As I’ve mentioned before I write a fair bit of SQL code for various projects or support calls and will be posting some of it here.
I recently created a report for a client to use to extract transaction lines to use to import as an accruals journal; as part of the extract I worked out the last day of the one month and the first day of the next to use as the transaction and reversing…