0

hi guys!

| -----------------------|---------------------|------------------------------|
| validation_period |-----sys_date-----|-------exp_date-----------| |------------------------|---------------------|------------------------------|
|-----------6-----------|---26/11/2008---|-(add validation_period-|
|------------------------|---------------------|field value into------------|
|------------------------|---------------------|sys_date)...?--------------|
|-----------------------------------------------------------------------------|
using ms access 2003 i got the system date by using date() function but the real job is to pass the validation_period (which is basically a number of month(s)) field value as a parameter into the dateadd() function to add the given number(s) of month(s) into the current date and store it under the exp_date.

please write me the solution of the problem...

thank you

4ukh

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by 4ukh
0

ops!

please consider this table...

thank yoy

4ukh

Attachments ms_access_daniweb.jpg 18.59 KB
0

Hi,

Try This Query:

Select TMonths, Date(), DateAdd('m',TMonths,Date()) From MyTable

Replace TMonths with your Numeric value/FieldName

Regards
Veena

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.