o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Compare the date from database to the date of the PC -

Hi

In my vb form, there is a text box for date of expiry. I used SQL command to get the date display at the text box. But, I wanted to compare the date displayed with the current date, date at the PC. If the date displayed is less than one month from the current data, an error message box will occur. The date displayed must be at least one month before the current dare. Can u show me some guidances to do on this? Can this be done?
Thank you.

 

Compare the date from database to the date of the PC -
Hi In my vb form, there is a text box for date of expiry. I used SQL command to get the date display at the text box. But, I wanted to compare the date displayed with the current date, date at the PC. If the date displayed is less than one month from the current data, an error messa

Compare Only Date not the Time (datetimepicker) -
Hallo, i have a problem with comparing two DateTimePickers, which both have the same date. but with Date.Compare(date1, date2) a voll comparsion with date and time is done. how can i just compare the dates.. (I have searched the forum and msdn...nothing found)

compare date in VB -
I have data field in database as "date" I would like to query, say 1 week or 1 month, and get the result in to recordset. How do I compare date? and know it's how many days from now?

Date only from a date/time -
I have a date in my Access database that stores the date/time. However I need to get just the date. The reason is, I am doing a compare with another date, and it messes up when the time is on there. i.e. if i do 9/19/2002 <= 9/19/2002 3:34:43 PM it returns false when i want it

question about date field -
Hi, I use date picker to let user pick the date and use that date to get a recordset from the SQL server and the field that I try to compare in SQL is defined as datetime stamp field. Do I have convert the dtpicker.value to date format first in order to compare the datetime stamp f

sqlquery to compare a given date with datetime field in a table. -
hi, how to compare a datetime field called date1 with date part alone. i want to compare the date part of the column with date input to select the matching record. show me the query. I want this as a stored procedure in sql server 2000 to access in my prg.

How to inform the user that a deadline is approaching -
Hello, after having stored an expiry date in the database, I need to warn the user two days before that date. I don't have any problems storing and retrieving the expiry date from the database. My question is, once I have retrieved the expiry date from the database and put it in a d

compare current date to datelastmodified -
i'm trying to look through the files in a folder and compare the datelastmodified to today's date/current date...if it's today's date, then take the name of file and write to a text. how do i compare this current date and datelastmodified...do i need to convert it to a specific format.

Date question !!! -
Hello, I wonder if there is a way to find out the input date is before or after a certain date.... I have a textbox1 in date format. After the user entered the date in to the textbox1, I'd like to compare it to see if it's before or after a cretain date... Thanks....

sql problem. -
rs.Open "SELECT * FROM [transaction] WHERE t_date=" & Date, db, adOpenStatic, adLockOptimistic hi... this sql query didn't work????? t_date is a date/time (data type) field in access database... i can't compare it with the current date.....so that all those re

[02/03] Comparing values -
I am doing the month calendar objects on one form and i save the date to the registry. I do this by creating the subkey and in that key I create a value and I pass the date from the month calendar control by doing monthCalendar.SelectionStart. This puts the date value into the regist

{Resolved}date manipulation in javascript -
Hi, I have a date in this format (20050427) so (yyyymmdd) I want to compare this date with today date how can I do that? Thanks for helping.

[2005] date comparison between vb.net and sql 2005 -
I am trying to compare an entered date with a date in sql2005. The field in sql is declaired as a date field. No matter what I put in the textbox, the code will not match up with the database. I know I am doing something in error. How do I compare what is in a textbox with a sql 20

Date Breakup in VB -
Hi guys, I am developing an application for foodgrains company, in which the stocks have expiry date. Now the stocks piled up are huge and its manually not possible to check the expiry date of each item. So i have to prepare a code where the expiry date entered during entry will com

How to compare Date -
Hello i want to compare Current Date with the field (entry_date) in My Access Database DB. How can i do. plz plz help me. i open recordset and write select statement with where clause . What comparison criteria in where clause will search records in rs. Tell me. plz.

"Next Date" method -
Heres the background: The user gets some data (from ms sql db) to a DataGrid by entering a Date. Then there is a button, "Next Date" that will find the next date in the row and bring up that data. What I am doing is this: I have a seperate dataTable will all the dates

Infernal date handling in SQL !!!! -
I have a date/time field in my access database (ie stored like 06/07/00 12:00:00) and I wish to do an SQL to find certain dates (ie. ignoring the time part of the data) I'm doing this: sSqlTxt="SELECT * FROM Letters WHERE DateSent = #" & Format(dtFrom.Value, "DD-M

VB and Getting a difference between Dates -
Im having a major brain freeze on how I should go about doing this. I want to compare the current date and time to a date and time from a database. If the date and time from the DB is behind the current date and time by more then an hour I want to be able to take action with code Ala

oracle - compare date -
hi, help needed! i'm doing a vb.net project! i use MS Access as my database at the beginning. so i use:- CDate(valid_date) < # " & DateTime.Now.ToString("dd/MM/yyyy") & "# to get some record that the valid_date is < than today date! it work wel

Dates format -
Dear All, I would like to compare a selected Date with a range of dates in sqlserver database. The date format is dd/mm/yyyy and computer system date is also the same. but the problem is when i run the query it doesn't return a result but if the matching date was in the format mm/

Compare dates from db to current date -
I have a problem. I retrieve some dates from a database in the format dd/mm/yyyy. These dates are stored in the database. what i want is to compare the date that i retrieved, to the current one, calculating the days between the two dates. afterward i want to place this in a column i

Date difference, urgent please look -
hello everyone, I need a way of finding the date difference from two dates. The problem is as follows: I need to compare the "todays" date, whith a date field from a Ms access database, table called tblDate Now, if the difference between todays date and the one in the dat

how to set a specified date to an object and compare with other dates -
I want to set the date of an date object to November 1st current year, and then compare this with another date. Can I convert the date objects to string and then compare, or will this give me an incorrect result?

System Date compared against a string -
Hi Back again! (great site - very helpful) Is it possible to compare the system date with a written date? I've shown the current date by: Label1.caption = date I've a list box which has several dates which the user clicks on to obtain information for that particula

vb.net - date -
hi, help needed! i'm doing a vb.net project! i use MS Access as my database at the beginning. so i use:- CDate(valid_date) < # " & DateTime.Now.ToString("dd/MM/yyyy") & "# to get some record that the valid_date is < than today date! it work wel

Comparing Dates - need some help -
I want to take the server date and compare it to two static dates. I want to then be able to manipulate the dates on the dtpicker control. Here is the code that I have but it does not work... It doesnt go into the if condition. The problem i am trying to solve is on users pcs there

Date Fields -
In my acccess database, there are many Date/Time fields. However, I have encountered a problem when I change the Regional Settings for Date format on my computer. I couldn't successfully compare the dates anymore. How do I overcome this problem? Thanks in advance.

Problem when update database with a date datatype -
I have a form with a few textboxes and a date field input (called txtDate). First of all, I will add all data on that form in SQL databse. I will insert NULL if txtdate is emplty. Later if I edit the form but don' edit txtdate. I have problem is in SQL database, the txtdate is added '1

MS Access - format date string -
I need to compare a date field for reporting purposes. My problem is, the Start_Date field is a date that looks like this: 20060822. How do I format the string so that 20060822 becomes 08/22/2006 so I can compare it to todays date? This is what I have so far..... cdate(forma

dates in an Access database -
I have a date in my database set as a short date which is not required and not indexed. I am using ADO and the date is entered via a text box on my screen. If the date is not entered at all everything is fine when the record is saved. If it is entered and the next time that record is

[2008] Convert string to date format and Date comparison -
I have a string value that represents a date. How can I... 1) convert this string value to a date value 2) compare the newly converted date value to Date.Now and test to see if it's more than 24 hours old The string format to be converted to date is: "yyMMddhhmmss"

compare time and date -
hi,please help.how to compare the time and date.current have 2 database table one is employee attendance table and employee overtime table.i want to compare the date and time to make sure the employee are preform the overtime on time.from the employee attendance and employee overtime t

[2008] Change Julian Date to Short Date -
I have a text Box(txtJulian) where user inputs julian date(YYddd) Later, I use this julian date to do calculations......However, I need to change the date format from Julian to Short Date in my code as the dates I compare against are all in Short date. I also need to leave the form

very eazy question -
how to compare date format when doing query For example SELECT DATE FROM TIME WHERE DATE=" " what should fill into the blank? my date format is like this dd/mm/yyyy hh:mm:ss

filter out dates before a given date -
Hi all, thanks for your help in advance. Here's my setup. I'm using VB and accessing an MSAccess database. I have some software thats in place in a bunch of different places, so the database format can't change (should've planned better earlier on), but that's another story.

Help with databound date time picker -
I am writing an app that uses date time pickers to specify when work on a unit has started and when it is finished. By default it shows todays date, and if I change it and save the changes, it will still show it after I change records. The problem lies with when i issue the fill comm

seperate date and time -
hi, i have feld in sql 2005 db that contains the time and the date how can i compare only the date(without time) to the date that i get from the user? omer

how to check the value in textbox is a valid date -
i need person to enter the date in the text box ,the date will be used for a SQL query, but if the person did not input a valid date , the program will be terminated. i have to avoid this bug , how? PS: my date format should be MM/DD/YYYY i was thinking to use a char arry to get

Compare Date/Time Elapsed... [resolved] -
Can anyone show me how to compare a date and time (that are hardcoded) with the current date and time ? And then show the elapsed time in seconds ? Any help is greatly appreciated.

compare two date fields -
How do i compare two date fields in VB one comes from the table and the other is the system date?