Member Avatar for 4ukh

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
  • 76 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by 4ukh
Member Avatar for 4ukh

ops!

please consider this table...

thank yoy

4ukh

ms_access_daniweb.jpg 18.59 KB
Member Avatar for QVeen72

Hi,

Try This Query:

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

Replace TMonths with your Numeric value/FieldName

Regards
Veena

Member Avatar for 4ukh

ok it works...
thank you for reply....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.