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.
5  4510 
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.
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?
=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.
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)
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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: androtech |
last post by:
Hello,
I'm looking for a function that returns a date range for a specified week
number of the year.
I'm not able to find functions like this anywhere. Any pointers/help would
be much...
|
by: Richard Hollenbeck |
last post by:
I'm trying to write some code that will convert any of the most popular
standard date formats twice in to something like "dd Mmm yyyy" (i.e. 08 Jan
1908) and compare the first with the second and...
|
by: Tjerk |
last post by:
Hello all,
I have the script below to change an image depending on the date upto
january it worked fine but then it just stopped working does anybody have an
idea how I can make it work again or...
|
by: Thomas R. Hummel |
last post by:
Hello,
I am importing data that lists rates for particular coverages for a
particular period of time. Unfortunately, the data source isn't very
clean. I've come up with some rules that I think...
|
by: Dr John Stockton |
last post by:
It has appeared that ancient sources give a method for Numeric Date
Validation that involves numerous tests to determine month length;
versions are often posted by incomers here. That sort of code...
| | |
by: captain |
last post by:
Below is the sql for data with same date need
to extract + or - 5 days data of same date also.
How to also get data of + and - days related to same date.
SELECT IM.Area,
IM.Location,...
|
by: Liz Malcolm |
last post by:
Hello and TIA. I have a DE form with an option group that if daily is
selected todays date is used for start and end date, if weekly is
selected Monday - Friday is used. I am trying to add a...
|
by: James P. |
last post by:
Hello there,
In my asp.net page using VB, I have a date text field in mm/dd/yyyy
format. When a date is entered, I'd like to validate it to make sure
the date is greater than or equal to the...
|
by: Assimalyst |
last post by:
Hi,
I have a working script that converts a dd/mm/yyyy text box date entry
to yyyy/mm/dd and compares it to the current date, giving an error
through an asp.net custom validator, it is as...
|
by: JJ |
last post by:
Here's the code.
$link="http://xbox360cheat.org";
$close_date=$_POST; #last content change check
if ($close_date == 0)
$close_date = date("Y-m-d H:m:s", mktime(12, 0, 0, date("m"), date...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
