Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
36  2479 
MLH wrote: Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
1 Day.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
MLH <CR**@NorthStat e.net> wrote in
news:ua******** *************** *********@4ax.c om: Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
Can't you read the FRIGGING HELP FILES?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
On Fri, 18 Nov 2005 13:32:22 -0500, MLH <CR**@NorthStat e.net> wrote:
This is poor programming. 1 what? Day? Second? Year?
Of course if you RTFM you would know, but better be explicit:
dtSomeDate = DateAdd("d", 1, dtSomeDate)
-Tom. Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
You have to be real careful using both expressions dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate). Say dtSomeDate is a Sunday and you want a query
to return all the records that occured Sunday to Saturday. You might think
that you would use Between dtSomeDate and dtSomeDate + 7 in the criteria or
Between dtSomeDate and DateAdd("d", 7, dtSomeDate). Wrong!! If Sunday would
be November 13, 2005, both dtSomeDate + 7 and DateAdd("d", 7, dtSomeDate)
give November 20, 2005; the following Sunday not the following Saturday. For
the criteria you need to use dtSomeDate + 6 and DateAdd("d", 6, dtSomeDate).
This is a case of COUNTING days so you need to use 6 rather than 7 to get 7
days. Now if you wanted ELAPSED days, that's different. 7 Elapsed days is
Sunday to Sunday so here you need to use 7 not 6.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
"MLH" <CR**@NorthStat e.net> wrote in message
news:ua******** *************** *********@4ax.c om... Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
"PC Datasheet" <no****@nospam. spam> schreef in bericht news:L7******** *********@newsr ead2.news.atl.e arthlink.net...
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.
You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
*************** *************** *************** ***********
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
Need a psychiatrist ...Contact me!
Arno R
What are you rambling on about? This has nothing to do with what the
original poster asked. Or is this just an attempt to add to the number of
pseudo answers you post per month? More than likely, another attempt to
place your solicitations in the newsgroups.
John... Visio MVP
"PC Datasheet" <no****@nospam. spam> wrote in message
news:L7******** *********@newsr ead2.news.atl.e arthlink.net... You have to be real careful using both expressions dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate). Say dtSomeDate is a Sunday and you want a
query to return all the records that occured Sunday to Saturday. You might
think that you would use Between dtSomeDate and dtSomeDate + 7 in the
criteria or Between dtSomeDate and DateAdd("d", 7, dtSomeDate). Wrong!! If
Sunday would be November 13, 2005, both dtSomeDate + 7 and DateAdd("d", 7,
dtSomeDate) give November 20, 2005; the following Sunday not the following
Saturday. For the criteria you need to use dtSomeDate + 6 and DateAdd("d",
6, dtSomeDate). This is a case of COUNTING days so you need to use 6
rather than 7 to get 7 days. Now if you wanted ELAPSED days, that's
different. 7 Elapsed days is Sunday to Sunday so here you need to use 7
not 6.
PC Datasheet
"MLH" <CR**@NorthStat e.net> wrote in message
news:ua******** *************** *********@4ax.c om... Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
Well if it isn't the dimmest of the dimwits who can't read read again!!
Didn't you get someone to read this thread to you? Or did your mother read
it to you when she can't read either? For your edification (oops is that too
big of a word for you?), the poster asked about adding an integer number of
days to the Date function and Mr. Stiphout suggested using the DateAdd
function. My response was about both of these issues!!!
Are you going to try and tell MLH that he didn't ask about adding an integer
number of days to the Date function just like you tried to tell another
poster he did not ask about default values?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
"John Marshall, MVP" <la******@stone henge.ca> wrote in message
news:Ar******** *************** *******@magma.c a... What are you rambling on about? This has nothing to do with what the
original poster asked. Or is this just an attempt to add to the number of
pseudo answers you post per month? More than likely, another attempt to
place your solicitations in the newsgroups.
John... Visio MVP
"PC Datasheet" <no****@nospam. spam> wrote in message
news:L7******** *********@newsr ead2.news.atl.e arthlink.net... You have to be real careful using both expressions dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate). Say dtSomeDate is a Sunday and you want a
query to return all the records that occured Sunday to Saturday. You
might think that you would use Between dtSomeDate and dtSomeDate + 7 in
the criteria or Between dtSomeDate and DateAdd("d", 7, dtSomeDate).
Wrong!! If Sunday would be November 13, 2005, both dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate) give November 20, 2005; the following Sunday
not the following Saturday. For the criteria you need to use dtSomeDate +
6 and DateAdd("d", 6, dtSomeDate). This is a case of COUNTING days so you
need to use 6 rather than 7 to get 7 days. Now if you wanted ELAPSED
days, that's different. 7 Elapsed days is Sunday to Sunday so here you
need to use 7 not 6.
PC Datasheet
"MLH" <CR**@NorthStat e.net> wrote in message
news:ua******** *************** *********@4ax.c om... Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
He asked about what Date = Date + 1 meant, no, more no less.
John... Visio MVP
"PC Datasheet" <no****@nospam. spam> wrote in message
news:uS******** *********@newsr ead1.news.atl.e arthlink.net... Well if it isn't the dimmest of the dimwits who can't read read again!!
Didn't you get someone to read this thread to you? Or did your mother read
it to you when she can't read either? For your edification (oops is that
too big of a word for you?), the poster asked about adding an integer
number of days to the Date function and Mr. Stiphout suggested using the
DateAdd function. My response was about both of these issues!!!
Are you going to try and tell MLH that he didn't ask about adding an
integer number of days to the Date function just like you tried to tell
another poster he did not ask about default values?
PC Datasheet
"John Marshall, MVP" <la******@stone henge.ca> wrote in message
news:Ar******** *************** *******@magma.c a... What are you rambling on about? This has nothing to do with what the
original poster asked. Or is this just an attempt to add to the number of
pseudo answers you post per month? More than likely, another attempt to
place your solicitations in the newsgroups.
John... Visio MVP
"PC Datasheet" <no****@nospam. spam> wrote in message
news:L7******** *********@newsr ead2.news.atl.e arthlink.net... You have to be real careful using both expressions dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate). Say dtSomeDate is a Sunday and you want a
query to return all the records that occured Sunday to Saturday. You
might think that you would use Between dtSomeDate and dtSomeDate + 7 in
the criteria or Between dtSomeDate and DateAdd("d", 7, dtSomeDate).
Wrong!! If Sunday would be November 13, 2005, both dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate) give November 20, 2005; the following Sunday
not the following Saturday. For the criteria you need to use dtSomeDate
+ 6 and DateAdd("d", 6, dtSomeDate). This is a case of COUNTING days so
you need to use 6 rather than 7 to get 7 days. Now if you wanted ELAPSED
days, that's different. 7 Elapsed days is Sunday to Sunday so here you
need to use 7 not 6.
PC Datasheet
"MLH" <CR**@NorthStat e.net> wrote in message
news:ua******** *************** *********@4ax.c om...
Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Monica Roman |
last post by:
Hello, help please.
I have a little macro that copies the date from a date/time field to a
memo field, BUT instead of going to the memo field it finds the first
date/time field and tries to copy there.
My first thought is to change the date to text but how?
Thanks!!!
Monica
|
by: Me |
last post by:
I need to get the past 5(x) months for certaing calculations. What I
have is listed below:
########################################
my $year, $month_str, $month_int;
foreach my $count (1..5) {
$year = `date --date '$count months ago' +"%Y"`;
chop($year);
|
by: lyndac |
last post by:
Hello!
Last night a job to create a view using DATE(CURRENT DATE - 1 DAY) received the current days date instead the previous days date.
Any one know why/how this can happen?
The DATE(....) is a hold over from when they use a hard coded date.
Is that scalar function impacting the result?
|
by: dkyadav80 |
last post by:
hi sir,
I have following problem:
code goes here:
{code]
1.
<html>
2.
<body>
|
by: viditsinghal |
last post by:
I need to write a C++ function that takes date as input and return day of the week as output.
Can i get it somewhere where all the possiblibilies are covered.
-Regards
VS
| | |
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| | |
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
