Time lapse between today's date and date entered

[jh3016]

I need help in calculating days from current date.

2 fields:
[InstallDate] (user will enter a date they expect to install the product)

[DiffinDate] (this would be a field that would calculate how long it will be before product is installed.

So

If [InstallDate] is <= 30 days from today, enter "30" in [DiffinDate]

If [InstallDate] is >30 and <=60 days from today, enter "60" in [DiffinDate]

If [InstallDate] is >60 and <=90 days from today, enter "90" in [DiffinDate]

If [InstallDate] is >90 days from today, enter "more than 90" in [DiffinDate]

After that, I would like to color code

30 would be green
60 would be yellow
90 or greater would be red

Any help would be greatly appreciated.

Thanks.

 

[mph1]

Try using the Case statement. Look at the following. You can also indicate the color you want to use.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vastmSelectCase.asp

Also, the numbers for the colors are:
Green 65280
Yellow 65535
Red 255

HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[SteveR77]

Access also understands vbGreen, vbYellow and vbRed as values to give you the colors however; these constants may not be what you desire.

HTH,


Steve

 

[KenReay]

Hi

If you need help with calculating dyas elapsed rather than how to use colours see DateDiff() function in help

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK