1. Home
  2. Point-Of-Sale Software
  3. Sql Help anyone?

Sql Help anyone?

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

Reply to
<nick
Loading thread data ...

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...

Reply to
Glenn Adams [MVP - Retail Mgmt]

Thanks Glenn

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

Reply to
<nick

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.