read date, then add 90 days, then format into yyyy-mm-dd

[kor]

Part of a script I am creating will terminate an active directory user. As part of the termination function I am going to be setting the account expiration date. I want to set the expiration date to 90 days from when the script is run. I then need to format that date into a yyyy-mm-dd format. I know how to read the date, but I don't know how to add 90 days or format it into the yyyy-mm-dd format specifically. Can anyone link me to some code to get me started?

Edited January 17, 2011 by kor

[somdcomputerguy]

See the _DateAdd() function in the Helpfile. As for formatting the date the way you want, there's different ways to do it. The StringSplit() function comes to mind first, breaking the string into elements, and using them in any order you want.

[JohnOne]

EDIT:

Same answer as above.

unable to delete.

Edited January 17, 2011 by JohnOne

[GEOSoft]

While StringSplit() may come to mind for some, I would probably do it with StringFormat()

[kor]

My code.

#include <Date.au3>

; Add 90 days to today
$vardate = _DateAdd( 'd',90, _NowCalcDate())
$date = StringReplace($vardate, "/", "-")
MsgBox( 4096, "", "+90 days: " & $date)