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

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

 

Question about DatePicker -
Hi Everyone, I am using a DatePicker Control and have a simple question I think. I am subtracting 5 days from whatever day I choose from the DatePicker control and sending that day to a field inside of an MS Access database. One problem though, the date being subtracted does not r

An easy question for All VB Masters -
Hi there, i need some help with this problem.... SELECT * FROM [Date] WHERE (date.date = #datevar#) AND (Date.RoomId = Roomvar) datevar = date() do... make date create SQL if record count <> 3 then add date to list end if loop until (365 dates checked)

Date Question -
I have a small question... If I want to assign a date to a date variable in the code... How do i do it... I want the variable datDiff to be equal to 01/00/00 (mm/dd/yyyy) What format does the date have to be in?

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

Date subtracting -
I need to search a listview for a date that's exactly six months before the current date. My question is, If the date format is 'DD-MM-YY" how would one subract the six months to see if the date meets the criteria ? Cheers!

[2005] SQL variable question -
I have no clue where this is supposed to go.. It's VB.NET with ASP.NET using SQL databases.. probably not uncommon, but a little confusing at times... So this is a SQL-side question. I need to have a date column in my table, but I don't want the time stamp. Time has its' own string

Crystal Reports Question!! -
HI!! I'm using CR 7 with VB 6 and I want to design a report with the structure as follows: From Date '20/04/02' to Date '23/04/02' ----------------------- Account : 1 Previous Acumm = 100 (Assuming 100 = sum of items with date < dateFrom) item 1 100 item 2 100

A quick date Picker Question. -
Hello In my VB6 program I have a text box that is populated by a date picker. When the form loads the date picker is set to Now. On the change event, of the date picker, I let the text box = date picker.value, however if the user clicks on todays date within the picker, which

Access -
This is not strickly a vb question but there are vb aspects to the thing i am producing. I have a table and the date fields have to be text (long story don't ask why) I have a query in access, where basically i need that date in date format (not text). so heres the question,

Database Date issue/question.. -
Hey guys...i have a quick question. i am loading the database into my flexgrid, but i want only the ones whos due date in the database file to less then the current date. Heres a sample code: Select firstname,lastname,phone,ToRentDate from rentals where ToRentDate <= datevalue('0

Another Time and Date question. -
Hi, First thanks to those who responded to my "Military Time" question. Your suggestions do exactly what I wanted. Now is there an easy way to do the following: I need to determine the difference between 2 dates and times. More specifically: I have a "start date

How to validate user when changing a date with the datepicker -
I want a message box to display when the user just click on the date picker or the date itself. If the answer is, "NO" then set the date back or leave the previous date alone. If "YES" then just change it. How could this be done? fyi: I have try coding it in a lo

Inserting Date into SQL from ASP -
Hi, Possibly a stupid question but what is the correct way to insert a date into a date field in SQL server 200 using ASP. I was using INSERT INTO table_me(date_me) values(now()) but it keeps on throwing up an error about converting from char to date or something like that, even

Date math question.. -
Ok, what I basically need is to be able to display yesterday's date... is there not a simple way of doing this? example: TextBox.Text = Today() -1 just today's date minus 1 day (the above doesn't work) anyone?

Date question (VBA Excel) -
I have a cell in which I need to display the date as whatever the previous Sunday was. Right now, since it is usually used on Monday, I am setting the value of the cell to Date - 1. I would like to set it to the previous Sundays date no matter which day it is. Any Help Appreci

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

Converting a Ordinal Date to Gregorian Date -
I have searched for a straightforward approach to the answer to this question, and have been unable to find one. I think certainly there must be a function written to do this, but all I have found and tried have not worked. Is there a straightforward way to convert a Julian Date to a

simple formatdatetime question -
Hi Friends, I have a litle problem. I am registering the date somone register a domain name on a mysql database. I use formatdatetime(date(),0) for the current date but how can i add one year on that date of more years? That would be the expiration date. Can somone help me with thi

how to check server date.. -
HI.. how date() function reflects my system (server)date ..instead of users system date..in my application.. Did u get my question...orelse..i can explain it clearly.. thanx & regards Anu.

Formatting a user settings date to a system settings date for Access -
Hi, I have been trying to look for this on the forums somewhere, but to no avail. I'm sure this is a common problem for people having to write code to support different locales using Access. When looking for records (ie when performing an SQL statement with the 'WHERE' in it,

Add time period to date -
I have date values and an integer value stored in a record. I have the user going through and picking which records need to be updated (this is for a calibration). Whenever they have selected the records they want, I want to add that integer value to the date in the record. So th

FileDateTime Question -
Hi, I'm using filedatetime to get the created date of a file,i know it returns the modified date but in my case both are the same so it makes no difference. Anyway i didn't like the format it displayed it in when i used: --------------------------- FileDateTime(filepath) ------

New Date Question -
Hi Everyone, I have a series of check boxes (in a control array named: chkDay, with the names of each day of the week on them) located inside of a frame control. I also have a Date Picker control on the form. My question is this. How can I select a day from the checkboxes and hav

ASP SQL Date Question Again... -
Hi all, What i need to do is check a field called work_dte in a a table to see if there's a record for every date up to the current date and if it's missing popup a message box saying "missing date blah". In asp does anyone know how? Any help is much appreciated! Than

Very simple Question -
Hi, This is an easy question but at present I can't remembe how to do it. Q. How is a System Date coded into a program? So if I want to ise the system date what is the syntax. Forgotten Mike

date of registration -
i have a register form and i want to insert the date of register into the database i m using ms sql 2000 how can i do that ? 2nd question: how can i deactivate an account after a time i choose ? 3rd question: how can i get the ip of the user on my site ?

A simple Calendar Question -
I am running VB6 with Office 2000 to connect to an Access2k Db. This is done via a data control called datTrinity my question is how do i instruct the app to goto the date clicked in the calendar control, but also move the data control to the corresponding date, which the contro

Help changing date -
Hi I have created a program that is supposed to change the system date and launch a program. For some reason when I change the date it do'nt take affect untill I check the date. My question is how do I check the date? Does anyone have any ideas as how to do this properly? Here is My

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

Easy way to pass values to Parameter Queries -
I am working on an Access database at work. (1) I have designed an unbound form which takes multiple inputs from a user: FacilityID, Beg. Date1, Beg. Date2, Beg. Date 3, End Date 1, End Date 2, End Date 3 (2) There are 16 different facilites and each has its own 3 sets of be

question about date -
I'm having problems making sure the date appears on my payroll form. I am not sure what the easiest way to do this is, but I used dtpicker and then set its value to = Date. I also used the value property of the dtpicker but I could not find a way to automatically update it every tim

date manipulation! -
A question for you... Well here are my scenario... User is suppose to enter starting date: dd-mm-yyyy into a textbox provided and enter ending date: dd-mm-yyyy into respective textbox. The program would have to trace the path, dir based on the date entered. My problems are how a

simple date question, but beats me -
hey all. im probably gonna get laughed at for this, but anyway: i need VB to be able to tell what day it is, and the date, and then work out when friday is, and fridays date. its so emails can automatically be sent at 5pm on a friday. help?

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

Date Picker/Month View Tandem -
Here is a question that I'm sure is easy to answer, but I can't figure it out. Anyway I have a month view calendar and an up/down date picker on a form. I want them to work in tandem. When the month view date is selected it will change the date picker date. And visea-versa, when

SQL Server date...help! -
I have a question. If I have a date in a textbox, but then delete it so it is blank. Then I update (save) it. When I open my form again and open that record, the date shows up like this: 1/1/1900 Why is that?

How can i use the date function! please help Simple question -
I am trying to calculate age against the current date but i dont know how to use the date function in the correct syntax help me please

Date Picker Question -
Hello all! New programmer, so this is probably an easy one... I have a date picker on a form. When I created it, VB put in 01/11/2000 in the Value property. What is the command to change that so it always displays the current date? Thanks for the help! ------------------ Greg T

Urgent Date Conversion Question -
I need to write a function that breaks up a numeric date in the format MMDDYYYY and converts it to the written equivalent, pops up a message box with the converted date and also returns the string. For example if user enters any date(01/0202002) It would convert to January 2, 2002 and

How to retrieve the privious date for the given date -
I need to find the previous date for the given date, i do date(now) - 1, this case works except the given date is 01. can any one plz help me to solve this issue. Thanks in advance