$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

code:

---

$DAY=SUBSTR("@DATE",9,2)
$MONTH=SUBSTR("@DATE",6,2)
$YEAR=SUBSTR("@DATE",1,4)
$lastmonth = val($month) - 1
? "Day is $day"
? "Month is $month"
? "Year is $year"
? ? "Last month is $lastmonth"
? ? "Paused"
get $c

---

[This message has been edited by Paul_Berquam (edited 06 February 2001).]

Thanks

code:

---

$DAY=SUBSTR("@DATE",9,2)
$MONTH=SUBSTR("@DATE",6,2)
$YEAR=SUBSTR("@DATE",1,4)
IF $MONTH = "01"
	$lastmonth = "12"
	$YEAR = val($YEAR) - 1
ELSE
	$lastmonth = val($MONTH) - 1
	IF $lastmonth < 10 $lastmonth = "0" + $lastmonth ENDIF
ENDIF
? "Day is $day"
? "Month is $month"
? "Year is $year"
? ? "Last month is $lastmonth/$YEAR"
? ? "Paused"
get $c

---

J.

_________________________