|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 21st, 2004, 07:58 AM
|
|||
|
|||
get date for the next 2 years
i have a form for processing claims. if an employee has
already claimed, he/she can claim again after 2 years. how can i calculate the date of next availment? any help or suggestion will be highly appreciated. thanks, bro 
|
|
#2
September 21st, 2004, 12:27 PM
|
|||
|
|||
|
DateAdd("yyyy", 2, MyDate) will add 2 years to whatever date is stored in
MyDate -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) wrote in message ... i have a form for processing claims. if an employee has already claimed, he/she can claim again after 2 years. how can i calculate the date of next availment? any help or suggestion will be highly appreciated. thanks, bro
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
| If statement | Doug | Worksheet Functions | 9 | June 28th, 2004 06:13 AM |
| more dates!!! | brigid | Running & Setting Up Queries | 6 | May 26th, 2004 10:59 AM |
| Formatting dates in Excel | bernrunner15 | New Users | 4 | May 11th, 2004 10:32 PM |
| Calculating Time employeed | Mark Graesser | Worksheet Functions | 4 | December 22nd, 2003 09:18 PM |
Linear Mode
