473,698 Members | 2,942 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

I need to pull data based on anything >Date()-2 3:00pm Ideas?

1 New Member
I need to pull data based on anything >Date()-2 3:00pm How would I do this to input into a query?
May 29 '15 #1
3 996
jforbes
1,107 Recognized Expert Top Contributor
I'm not exactly sure what you are trying to do, but you might want to look into the DateDiff() function.
May 29 '15 #2
Rabbit
12,516 Recognized Expert Moderator MVP
You mean 2 days before today at 3pm? Use the DateAdd function to sutract 2 days. Truncate the time portion. Use DateAdd to add 15 hours.
May 29 '15 #3
NeoPa
32,569 Recognized Expert Moderator MVP
Rather than modifying your data I would suggest finding the value that you're after and compare your data with that. Generally that value will only need to be calculated once for the whole query.
Expand|Select|Wrap|Line Numbers
  1. DateAdd('h',15,DateAdd('d',-2,Date()))
May 31 '15 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
2495
by: cvillard | last post by:
I am new to SQL, as old as it is. I am not new to programming I normally just use Access. I have two tables for a little project manager I made. After updates I sent an email to the user. I need to populate the user based on the "Assigned To" field I use, but I only log the username and not the email address. Is there a way to associate the "Assigned To" to the User's account in the "User" table so that I can pull thier email address...
5
5092
by: Mark Broadbent | last post by:
Does anyone know why some genius decided that data based breakpoints are not supported in C#/ vb.net debugging? Is there some technical reason Or has it been done to make breakpointing more fustrating than ever? --
2
6950
by: Jeremy Dillinger | last post by:
I have a program setup to pull data from a database. My database table has things such as (category, Item, price, etc.) In my program I want to have multiple list boxes that will have a pull down list of different categories. The category is stored as a number and the item is stored as a string. Also once the item is picked from the list I would also like to extract the price corresponding to the chosen item. This program will be to...
3
1515
by: jjgardner3.web | last post by:
Hello I have a very simple xml file: <?xml version="1.0" encoding="ISO-8859-1"?> <?xml-stylesheet type="text/xsl" href="./status.xsl"?> <IEC> <Workstation> <Hostname>HOSTNAME</Hostname> <CurrentPkg>PKGNAME</CurrentPkg> <TimeRunning>15 min</TimeRunning>
2
1433
by: jimstruckster | last post by:
I'm looking to display information pulled from a database based on information the user puts into a text box. The user will enter their sales rep number and I want to hit a table and return their name as soon as they tab off of the text box. Any ideas or help would be appreciated, Thanks
0
1239
by: napstar | last post by:
I have an excel file with data.I want to pull data from the excel file into a table in access.The data in excel has products and customers who buy these products and sometimes 1 customer can buy many products. If i import into access will be able to show this realtionship? Please guys, this is urgent Thank for your anticipated responses..
6
4412
by: kthequeen | last post by:
Is it possible to pull data( text contents and the file attribues, like filename ) from a pdf file and store in sql? ..using c# I have web app with 100+ pdf files that I need keyword search capability for. It would produce results with link(s) to the corresponding pdf file. Not sure if this is possible. thanks!
2
1346
by: rush81 | last post by:
Hello All, I want to pull data against two fields from table. The combination of these fields give unique result like '123 VA' or '0123 VA' One field has entries like 0123 and 123, one entry with leading 0. They are same but this is data entry mistake. Can you suggest me on how to go about this one? I could find exact matches but need to work on this substring match. Please respond at the earliest. Also do let me know if any other...
4
2904
by: Emily Crawford | last post by:
I have a query that has two date fields. One date field is from the Request Table and it is called RequestDate - the date the employee requested training. The second date field is called ClassTaken from the Enrollment Table - and it is the day the employee took the training they requested. I am trying to create a report that asks the user to input one set of dates for the RequestDate field and a different set of dates for the ClassTaken date...
0
8683
marktang
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...
0
8610
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
9170
Oralloy
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...
0
8873
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
7740
agi2029
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...
1
6528
isladogs
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...
0
5862
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
4623
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2339
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.