There is often a need to get a date in the furure or the past, like exactly a month ago or 7 days from now etc. The function DateAdd is used for that:
Dim dDate
dDate = Now()
dDate = DateAdd( "d", 123, dDate )
This adds 123 days to the current date
'We could use a negative number to get back in time...
br>
dDate = Now()
dDate = DateAdd( "d", -53, dDate )