473,946 Members | 4,202 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Am confused as to what Date = Date + 1 means?

MLH
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

"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. ..
"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.


<sarcasm>
Be careful Bob, if you contradict Steve, he'll use the "d" word on you too!
</sarcasm>

Nov 20 '05 #21

"PC Datasheet" <no****@nospam. spam> wrote in message
news:p7******** *********@newsr ead1.news.atl.e arthlink.net...
And what about the lie you perpetrated... are you willing to retract it and apologize?


Sure Steve. Just as soon as you stop advertising on CDMA.

Nov 20 '05 #22
Yes, and what do you think x and y were in my response ---
Adding a number to a date !!!!!

--
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!


"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. ..
"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.

Nov 20 '05 #23
So you admit you LIED !!!!

--
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!


"Randy Harris" <ra***@SpamFree .com> wrote in message
news:tA******** ********@newssv r17.news.prodig y.com...

"PC Datasheet" <no****@nospam. spam> wrote in message
news:p7******** *********@newsr ead1.news.atl.e arthlink.net...
And what about the lie you perpetrated... are you willing to retract it

and
apologize?


Sure Steve. Just as soon as you stop advertising on CDMA.

Nov 20 '05 #24

"PC Datasheet" <no****@nospam. spam> schreef in bericht news:hH******** *******@newsrea d2.news.atl.ear thlink.net...

<snipped lunatic madness here>
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

Nov 20 '05 #25

"PC Datasheet" <no****@nospam. spam> schreef in bericht news:fG******** ******@newsread 2.news.atl.eart hlink.net...

<snipped lunatic madness here>
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

Nov 20 '05 #26
PC Datasheet wrote in message
<_6************ ****@newsread3. news.atl.earthl ink.net> :
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!!!!!


From this statement by Randy Harris

"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."

You get furious with the replying to own questions part.

So you admit:
* looking "for any excuse to advertise your incompetent
service"
* "In addition to posting off topic, you post incorrect
solutions"

Thank you for admitting this - and could you now please
stop it.

--
Roy-Vidar

Nov 20 '05 #27
"PC Datasheet" <no****@nospam. spam> wrote in message
news:fG******** ******@newsread 2.news.atl.eart hlink.net...
Adding a number to a date !!!!!


Is there something wrong with your exclamation mark key?
Nov 21 '05 #28
"PC Datasheet" <no****@nospam. spam> wrote in news:fGRff.526$ aA2.87
@newsread2.news .atl.earthlink. net:
Yes, and what do you think x and y were in my response ---
Adding a number to a date !!!!!

No! Your response was about determining if a number was between a
second number and third number. The fact that you used date numbers
as an example is irrelevant to the concept of determining whether a
number lies between other numbers.

--
Bob Quintal

PA is y I've altered my email address.
Nov 23 '05 #29
There must be something in the water at sympatico.ca! This is the same isp
as John Marshall dwt(sic dimwit).
My post started out with "You have to be real careful using both expressions
dtSomeDate + 7 and
DateAdd("d", 7, dtSomeDate)." Both are adding an integer to the Date
function and my point was that one must understand what value results when
you add an integer to the Date function. No one can be as dimwitted as John
Marshall!!!

--
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!


"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. ..
"PC Datasheet" <no****@nospam. spam> wrote in news:fGRff.526$ aA2.87
@newsread2.news .atl.earthlink. net:
Yes, and what do you think x and y were in my response ---
Adding a number to a date !!!!!

No! Your response was about determining if a number was between a
second number and third number. The fact that you used date numbers
as an example is irrelevant to the concept of determining whether a
number lies between other numbers.

--
Bob Quintal

PA is y I've altered my email address.

Nov 23 '05 #30

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2048
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
1
5563
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);
3
7913
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?
1
1411
by: dkyadav80 | last post by:
hi sir, I have following problem: code goes here: {code] 1. <html> 2. <body>
3
1804
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
0
9975
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,...
0
11141
jinu1996
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...
1
11324
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,...
0
10679
tracyyun
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...
0
7403
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();...
0
6097
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...
1
4928
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
2
4524
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3525
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.