I am trying to come up with a formula to take todays date and subtract 1 day from the final date stamp. I need to have the final output in MM/DD/YYYY format which will then be written to an INI file.
$month = @MONTHNO
$day = @MDAYNO -1
$year = @YEAR
If $month < 10
$month = "0@MONTHNO"
EndIf
If $day < 10
$dayminus1=@MDAYNO - 1
$day = "0$dayminus1"
EndIf
If @MDAYNO = 1
Select
Case @MONTHNO = "1"
$month = "12"
$day = "31"
$year = @YEAR - 1
Case @MONTHNO = "2"
$month = "01"
$day = "30"
Case @MONTHNO = "3"
$month = "02"
$day = "28"
If @YEAR = "2008"
$day = "29"
EndIf
Case @MONTHNO = "4"
$month = "03"
$day = "31"
Case @MONTHNO = "5"
$month = "04"
$day = "30"
Case @MONTHNO = "6"
$month = "05"
$day = "31"
Case @MONTHNO = "7"
$month = "06"
$day = "30"
Case @MONTHNO = "8"
$month = "07"
$day = "31"
Case @MONTHNO = "9"
$month = "08"
$day = "31"
Case @MONTHNO = "10"
$month = "09"
$day = "30"
Case @MONTHNO = "11"
$month = "10"
$day = "31"
Case @MONTHNO = "12"
$month = "11"
$day = "30"
EndSelect
EndIf
$date="$month/$day/$year"
_________________________
I haven't failed. I just found another way that did not work.