By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Date

P: n/a
Joe
In Excel you are able to write a formula
=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())) which will return
todays date 1 year ago. I'm not sure if I am explaining this right so
bear with me. Is there a similar function in Access that I can you in
a text box? Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Did you mean something like Date()-365
"Joe" <jo**@cogeco.ca> wrote in message
news:p5********************************@4ax.com...
In Excel you are able to write a formula
=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())) which will return
todays date 1 year ago. I'm not sure if I am explaining this right so
bear with me. Is there a similar function in Access that I can you in
a text box? Thanks.

Nov 12 '05 #2

P: n/a
Joe
On Wed, 03 Sep 2003 01:24:49 GMT, "Omey Samaroo"
<no****@replytogroup.com> wrote:
Did you mean something like Date()-365
"Joe" <jo**@cogeco.ca> wrote in message
news:p5********************************@4ax.com.. .
In Excel you are able to write a formula
=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())) which will return
todays date 1 year ago. I'm not sure if I am explaining this right so
bear with me. Is there a similar function in Access that I can you in
a text box? Thanks.

Thanks, didn't realize it was so easy. The next question could be a
bit harder. How do I make it default to Jan 1 of the current year?

Nov 12 '05 #3

P: n/a
=DateAdd("yyyy",-1,Date())

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Joe" <jo**@cogeco.ca> wrote in message
news:p5********************************@4ax.com...
In Excel you are able to write a formula
=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())) which will return
todays date 1 year ago. I'm not sure if I am explaining this right so
bear with me. Is there a similar function in Access that I can you in
a text box? Thanks.

Nov 12 '05 #4

P: n/a
On Wed, 03 Sep 2003 02:24:06 GMT in comp.databases.ms-access, "Tim
Mills-Groninger" <ti***@earthlink.net> wrote:
dateserial(year(date())-1,month(date()),day(date()))

Microsoft is a bit like the former Soviet Union when it comes to consistancy
between applications. Excel's Today function maps to Access's Date(),
Excel's date becomes Access's DateSerial. And don't even get me started on
string functions. sigh.


How about string theory then? Access supports eleven dimentional
arrays <g>

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)
Nov 12 '05 #5

P: n/a
On Wed, 03 Sep 2003 18:51:24 +0100 in comp.databases.ms-access, Trevor
Best <bouncer@localhost> wrote:
or use DateDiff()


or even DateAdd().. d'oh! :-)

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.