Date math and fomatting

[kaotkbliss]

I display the date (@YEAR&@MON&@MDAY) to get something like 20090904 (exactly as I want the format) yet, if I do any adding or subtracting days it drops leading zeros such as

@YEAR&@MON&@MDAY-1 would yield 2009093

@YEAR&@MON-1&@MDAY would end up 2009903

how can I keep this from happening? I looked through the _date functions but all had different date formats and I could not seem to get them into the YYYYMMDD format I need.

[GEOSoft]

$sDate = Number(@Year & @Mon & @MDay)
$sNew = Number(@Year & StringFormat("%02d", @Mon-1) & StringFormat("%02d",@MDay))

[weaponx]

You can't directly perform math on dates. What do you get when you subtract from the first day of a month? Zero. What do you get when you add a day to the end of a month? 32.

Use _DateAdd

[kaotkbliss]

You can't directly perform math on dates. What do you get when you subtract from the first day of a month? Zero. What do you get when you add a day to the end of a month? 32.

Use _DateAdd

I thought that might happen, but I read in another post where someone was doing something similar so I was hoping.

So it would be something like _DateAdd('d',1,YYYYMMDD)?