UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Add 1 year to a date field to append to a new table ...    
 
   
TheZjooj
post Aug 28 2007, 12:22 PM
Post #1

UtterAccess Guru
Posts: 620
Hello all,


It's been a while since I have used access...
Could anyone help me with trying to figure out how to add a year to a date field in an append query so
that it appends the new record with the next year?

I was trying:

Expr1: MyDate+1

but that only increases it a day...

Any help would great!!

Thanks,

Zjooj
Go to the top of the page
 
+
fkegley
post Aug 28 2007, 12:23 PM
Post #2

UtterAccess VIP
Posts: 23,583
From: Mississippi
Expr1: DateAdd("yyyy", MyDate,1)
Go to the top of the page
 
+
freakazeud
post Aug 28 2007, 12:32 PM
Post #3

UtterAccess VIP
Posts: 31,413
From: NC, USA
The syntax is the other way around:

Expr1: DateAdd("yyyy", 1, MyDate)

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
TheZjooj
post Aug 28 2007, 01:57 PM
Post #4

UtterAccess Guru
Posts: 620
Perfect!! Thank you both!!!
Go to the top of the page
 
+
freakazeud
post Aug 28 2007, 02:07 PM
Post #5

UtterAccess VIP
Posts: 31,413
From: NC, USA
You're welcome.
Glad we could assist.
Good luck on future projects!
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 06:20 AM