dave
Posts: 9
|
| Posted: 09/18/2006, 7:40 AM |
|
I'm trying to set an expiry date on insert of a new record. Using custom insert I can setup an expression no problem to force it to be current date using the Now() function, but how can I add 30 days to the current date? Any help would be appreciated.
TIA
|
 |
 |
matheus
Posts: 386
|
| Posted: 09/18/2006, 7:48 AM |
|
Which database?
This is a database resource.
Look in database documentation. "Date Functions".
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
|
dave
Posts: 9
|
| Posted: 09/18/2006, 7:51 AM |
|
sql server.
|
|
|
|
dave
Posts: 9
|
| Posted: 09/18/2006, 9:22 AM |
|
Got it on the database.
(dateadd(month,(3),getdate()))
thanks matheus
|
|
|
|
|
