Date function

[Asterix]

Hi,

Í need to get a date dd-mm-yy minus 1 week

thanx for your help

[carlosapv]

use this:

d = Format(Date - 7, "dd-mm-yy")

rest once week only.

[SonGouki]

You could also use the more robust DateAdd function, example as follows:

Dim dtCurrent As Date
Dim dtPrevWeek As Date

dtCurrent = DateValue("2000-Feb-15")
dtPrevWeek = DateAdd("ww", -1, dtCurrent)
debug.print dtPrevWeek

>> Outputs "02/08/2000"

If you look up this function you'll see that it provides alot more functionality.

Later.