473,322 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

fetching data between 2 dates

Hi all,
I have a code that gives me the details from a tool for a given date.
Expand|Select|Wrap|Line Numbers
  1. sysdate = Date
  2. If dtrange = "True" Then
  3. BugFilter.Filter("BG_DETECTION_DATE") = sysdate
  4. End If
  5. Set BugList = BugFilter.NewList
  6. QCConnect
But, i want to get the details for a date range.
I have used a startdate and todate as follows.
but not sure of the logic to implement. have tried a lot but in vein.

Expand|Select|Wrap|Line Numbers
  1. fromdate = InputBox(prompt:="enter the from date.", Title:="ENTER THE FROM DATE", Default:=sysdate)
  2. todate = InputBox(prompt:="enter the to date.", Title:="ENTER THE TO DATE", Default:=sysdate)
  3. If dtrange = "True" Then
  4. BugFilter.Filter("BG_DETECTION_DATE") = sysdate
  5. End If
  6. Set BugList = BugFilter.NewList
  7. QCConnect
Please help.
Mar 28 '11 #1
0 1078

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

Similar topics

1
by: Srinivasan R | last post by:
Hi, I am trying to get asynchronous fetching of data from sql server database. I would like to show the progress of fetching records in GUI. Is there any simple/complex steps for the same in C#...
1
by: deepdata | last post by:
Hi, I am trying to fetch data from db2 (express version) database by calling stored procedure. I have tried to use both cursor and for loop but still i am getting error. --======Start...
9
by: Jenden0 | last post by:
I'm new to C# (and Microsoft in general) so this may be a simple problem, but I haven't been able to figure it out yet. I've got a database with a number of different tables and I want the user...
2
by: ameen.abdullah | last post by:
Hi Guys, I have a datagrid which is binded to dataset which is gettting data from xml. Now i need to know if i edit or add data to the datagrid, whats the best possible way to fetch it? .. i...
0
by: Bhavesh | last post by:
Hello genious people, I m trying to insert a LARGE text from Multiline Textbox into my table of sqlserver2000. I m using vs-2005. Please note that I dont want to store blob data From FILE TO...
1
by: itChirag | last post by:
Hi I want to know how data is fetched from web page & stored in sql data base. I have the design of webpage but cannot save data in sql table. please help!
1
by: Frank Moyles | last post by:
I have two simple function in PHP that I want to convert to C# - function Doit($enc_user_name, $enc_password) { $result = $mysqli->query("call sp_userAuth('$enc_user_name','$enc_password')"); ...
6
by: BonnieW via AccessMonster.com | last post by:
I inherited a table. One field in this table is Date_Observed, and users entered data directly into this (I'm not sure there was an input mask; if there was, it was ignored). It is formatted as a...
3
dj12345
by: dj12345 | last post by:
Hi, I have 2 Gridviews on my asp.net page. In this gridview i am showing list of links. I want to update these links dynamically after 5-10 seconds, without refreshing the page(without postbak) i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.