Date function giving a date 1

[sinbadly]

Is there a way to get the date function to say when the given date in a field is 21 days away, please, and to show that date?

 

[SkipVought]

Hi,

dim dNewDate as date
dNewDate = Date + 21

Skip,

_[red][/red]

 

[Andrzejek]

Go to your Help and check:

DateAdd
DateDiff
Date

You will find a lot of information about Dates.

---- Andy

 

[phish20002003]

I use conditional formatting often when checking dates. Mostly changing the back color from green to yellow to red.

-phish

 

[sinbadly]

Thanks very much for that, SkipVought. And thanks too to Andrzejek and phish20002003. I found a useful tutorial on this question on MArtin Green's excellent site, fontstuff, by the by.