I'm running a report that records data for the previous month. I have broken down the date all ready but can't get it to read the month before..


$DAY=SUBSTR("@DATE",9,2)
$MONTH=SUBSTR("@DATE",6,2)
$YEAR=SUBSTR("@DATE",1,4
02/01/2001
I need 01/01/2001

Can the month be subtracted with a value?

Help