Sql Help anyone?

Mar 14, 2005 2 Replies
<

Hey guys, this is a off topic question kind of, but here goes anyway.



I am creating a form for my company intranet that has the current date already added, now I need to have it automatically create a expiration date



365 days into the future and have it populate its own field in the table. Anyone have any ideas on how to write this into my form?

Thanks, Nick


Vote
Twitter Facebook LinkedIn
G

In SQL, it's DATEADD(yy,1, getdate())

If you want to do it in the form rather than in the database, it depends on the language you're using, but most have something along the lines of DateAdd...

Vote
Twitter Facebook LinkedIn
<

Thanks Glenn

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP12.phx.gbl...

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required