|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
add one year to registration date?
Hi every body;
how I can add one year to the registration date field using ms-access ? thanks |
|
#2
|
||||
|
||||
|
UPDATE tablename SET regdate = dateadd("yyyy",1,regdate)
That'll update all records. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > add one year to registration date? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|