Thanks for your interest. At the moment I do this
MONTH=`date +%m`
case MONTH in
01) NEWDATE="01/12/09 and 31/12/09" ;;
02) NEWDATE="01/01/10 and 31/01/10" ;;
etc
*) exit 0
esac
I have a number of instances wher I need to run reports for the previous month and need to include the last months date range in the sql.
I want to create a string which consists of the first and...