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?
Nov 18 '05
36  2498 
"PC Datasheet" <no****@nospam. spam> schreef in bericht 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!!!
IME the OP indeed did *not* ask for that!!
But I guess you were only trying to be *really* helpful to the poor poster here ...
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?
Steve, that 'misunderstandi ng' (from you that is ...) happened in another newsgroup !!
Don't bother *us* here with that, or you might even get plonked by one of us ...
<snipped all the advertising>
Arno R
Well Dimwit, that is the Date function plus an integer. That's what I said!
Are you also saying Mr Stiphout was out of line adding his suggestion about
the DateAdd function? And how about Mr. Fenton? Are you saying he was out of
line when his comment was about the Help files? FRIGGING is probably too big
of a word for you to understand. It probably took it totally out of your
grasp when he used all caps!!
Your ignorance is glowing brightly!!!!
--
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:u-*************** *************** @magma.ca... 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?
How does the saying go, "....dimwit eers flock together"?
And BTW, there was no misunderstandin g on my part! It was dimwiteer Marshall
who argued with the poster about what the poster said.
--
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!
"StopThisAdvert ising" <StopThisAdvert ising@DataShit> wrote in message
news:43******** ************@dr eader2.news.tis cali.nl...
"PC Datasheet" <no****@nospam. spam> schreef in bericht
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!!!
IME the OP indeed did *not* ask for that!!
But I guess you were only trying to be *really* helpful to the poor poster
here ...
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?
Steve, that 'misunderstandi ng' (from you that is ...) happened in another
newsgroup !!
Don't bother *us* here with that, or you might even get plonked by one of us
....
<snipped all the advertising>
Arno R
Listen to the pot calling the kettle black. You would seem to be the one who
doesn't know how to read. Your post had nothing to do with the original
question. You simply look for any excuse to advertise your incompetent
service. In addition to posting off topic, you post incorrect solutions and
post replies to questions you have posted yourself with other identities.
Given your childish, unprofessional behavior, anyone would be insane to hire
your PCDataSheet services.
"PC Datasheet" <no****@nospam. spam> schreef in bericht news:Px******** *********@newsr ead2.news.atl.e arthlink.net...
To all: Sorry for this redundant post but it's a (semi-)automated reply .... ;-) 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
"PC Datasheet" <no****@nospam. spam> schreef in bericht news:0u******** *********@newsr ead2.news.atl.e arthlink.net...
To all: Sorry for this redundant post but it's a (semi-)automated reply .... ;-) 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
I guess there are four dimwits!!!
I NEVER posted a question to any newsgroup and then answered it myself. You
are just a blatant LIAR!!!!!
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:Cz******** ******@newssvr3 3.news.prodigy. com... Listen to the pot calling the kettle black. You would seem to be the one
who
doesn't know how to read. Your post had nothing to do with the original
question. You simply look for any excuse to advertise your incompetent
service. In addition to posting off topic, you post incorrect solutions
and
post replies to questions you have posted yourself with other identities.
Given your childish, unprofessional behavior, anyone would be insane to
hire
your PCDataSheet services.
"PC Datasheet" <no****@nospam. spam> wrote in message
news:_6******** ********@newsre ad3.news.atl.ea rthlink.net... I guess there are four dimwits!!!
Well Steve, if anyone who objects to your advertising in cdma is a dimwit, I
guess there are at least 4 of us.
"PC Datasheet" <no****@nospam. spam> wrote in
news:Px******** *********@newsr ead2.news.atl.e arthlink.net: How does the saying go, "....dimwit eers flock together"?
And BTW, there was no misunderstandin g on my part! It was
dimwiteer Marshall who argued with the poster about what the
poster said.
The OP asked about adding a number to a date. You were completely
off the mark talking about "between x and y, giving an extra day.
That had nothing to do with the original topic. Fencepost errors
are something much more generic than with dates.
--
Bob Quintal
PA is y I've altered my email address.
And what about the lie you perpetrated... are you willing to retract it and
apologize?
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:kO******** *******@newssvr 24.news.prodigy .net...
"PC Datasheet" <no****@nospam. spam> wrote in message
news:_6******** ********@newsre ad3.news.atl.ea rthlink.net... I guess there are four dimwits!!!
Well Steve, if anyone who objects to your advertising in cdma is a dimwit,
I
guess there are at least 4 of us.
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
