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

Calculating Date Time pickers -

I have two time pickers where one is for employee time in and other is for employee time out..

I would like to make calculation so whe emplyee enter time in and enter time out label1.caption shows the time he spent in work ...

Can somebody help me with that...

Thanks in advance for ur help

 

Calculating Date Time pickers -
I have two time pickers where one is for employee time in and other is for employee time out.. I would like to make calculation so whe emplyee enter time in and enter time out label1.caption shows the time he spent in work ... Can somebody help me with that... Thanks in advanc

REQ help: Calculating elapsed time from date/time began from Date/time ended -
I have four controls, two are Date-Time Pickers set for Date and the last two are text boxes set for Time with the "...If Not IsTime()..." validation. It is the standard Date and Time problem began, Date and Time problem ended. I am trying to calculate the elapsed time betw

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

Date/Time Pick -
I am using the DT Picker. I have the date ones setup correctly, and know how to setup the Time one. When I get data from the Date Pickers it works using DTPicker2.Value, but when I use the same code on the DT Time, I get both date and time. All I want is the time.

Checking date problem!!! -
I have 2 date time picker for the date and 2 date time picker for the time. we name those date time pickers as departureDate, arrivalDate, DepartureTime, and ArrivalTime. What is the code to check if the user enter the valid departureDate and arrivalDate? What I mean is there is no

How do I combine a date and a time (RESOLVED) -
I have two time pickers, one for Date, and one for time. Now I want to store the results in one DateTime object. So I have a say 6/30/2004 12:00:00am date and a 6/23/2004 3:33:00 am time, and I want 6/30/2004 3:33:00 am

The first and last day of the month -
I have 2 date pickers that I want my users to sepcify a range for a sql statement. When form loads I wnat these pickers to default to the first of the current month and to the lst day of the current month, respectively. How can I do that

Calculate Days... -
I have 2 date pickers and I want to calculate number of working days which is monday-friday and number of weekend days which is saturday and sunday from the dates chosen in 2 date pickers. so for example if I choose 01/08/2002 and 13/08/2002 then the answer I will get will, 9 worki

Strange DateTimePicker Behavior -
Ok, So I have a weird issue with my date time picker. when i minimize my form, it minimizes and removes itself from the taskbar when I restore it it goes back to the taskbar The strange part is that when it gets restored, the data in all of my date time pickers gets changed to

handling date picker values -
this date picker is bugging me a lot .i have two date pickers dt1 dt2.when user selects a date in dt1 the day value in dt2 should increase by 15 days . i tried something like dt2.day = dt1.day + 30 the msdn help was too complex for me to understand suggestions plz...

Calculating Date and Time -
How do i calculate date and time in vb. What i mean is i have a date 8/27/01 5:42 PM and 9/06/01 12:32 AM, how do i find out how many day,hours,min that is. Thanks

Date Time Picker Troubles (RESOLVED) -
Okay, I have a program I'm writing for a friend. There is a form to add a new record to a file. At the bottom of this form are three date-time-pickers. These are generally the last things a user will change on this form. Next to each DTP is a label that shows a date after the date sele

understanding timespan -
i searched on it, and couldn't come up with anything helpful enough for my particular issue, so will ask the specifics here. I need to calculate the time difference across midnight, from a given date and time to another given date and time, and based on how long assign a value to it

Calculating Age from Date of Birth -
What would a good way be of calculating the Age of a person from a Date of Birth?

RESOLVED: Validating date in datatable -
Hi All, I have a datatable bound to a datagrid, I am stepping through the datatable to check to see if the current row is valid (boolean value) and to see if the date in the current row falls between the dates of my date pickers. This is what I have so far: Code: With dtP

Date Time Picker - Remove Time -
I have a bunch of datetime pickers on my form. When I step through my program using F8 I notice that when the dtPicker is not changed by the user it writes a value to the database such as "07/25/2005". The problem I'm having is that when the user changes the date on th

Calculating Date/Time from an Offset {Resolved} -
In C++ a time can be handled as a long from some offset date -- usually 1/1/1970. If I have a long (which represents # of seconds since 1/1/1970 how do you convert it to a date in VB?? Thanks David

Problem while Copying project files from one pc to another -
Hello All I am stuck in a problem. I have copied my project file to another computer.When i tried to open it, it gave me an error MDCOMCT2.ocx Not loaded properly. When i clicked on OK and tried to open the forms, the forms with Date pickers gave an error message saying this f

Help with storing DATE -
Could any one please tell me how I should convert a given string into date format to store and retrieve from the database? I dont want to use any date pickers so I have created a masked control which takes entry in the format ##/##/#### Now when I store this (MM/DD/YYYY - as it

calculating a future date -
ive been searching the forum for an answer to my question but cant seem to find a solution to my problem. Im doing a very simple application that is calculating a future date but im having problems figuring out how to make it work. What i need is a datetimepicker from which i can choo

calculating the week beginning date. -
Hi, I'm using the MonthView control for the first time, what I want to do is calculate the week beginning date on startup and when a person choses a date, i.e. todays date being the 29/03/2006 I need to enter the week beginning date of 27/03/2006 into a text box. I then plan to use thi

Calculating a year time span -
How can I check to see that a date entered by the user is no more than one year from the current date? Better yet, any number of years entered. For instance, the user would enter a 2 year time span and determine if today's date falls within a two year time span.

Calculating date... -
I need to calculate the upcoming Saturday date from current date. Is their an easy function to do this?

Calendars and Date Formats -
Hi, I have created a calendar using the Calendar Control 11.0 option in the toolbox and have linked it to a text box in a user form. However, I cannot get the date to display in European format i.e. dd/mm/yy. When I am calculating the difference between 2 dates using the 'datediff'

Help with DateTimePicker! -
Okay, I cannot even comprehend on the code needed to do this. I have two "Date Time Pickers", and I need to find the amount of days imbetween the dates selected on each one. I know the simple solution to get the days if the time selection is in the same month and the same yea

Error using date picker - looking for fix -
Hello, I am using the date picker control that comes with the Microsoft common controls (mscomct2.ocx version 6.0.88.4 ) in VB 6.0. The error I am having is this. I have connected the date pickers up via ADO and am running SQL queries on my data. Everything works fine. Except when

Calculating monthly bill date -
Hello all, I'm doing a simple db that stores customers using an internet service, billed monthly. How do I automatically calculate the monthly billing date. This will be the same date every month based on the date service began. The start date is stored in the database, but I am not

[2008] Calculating timespan -
Working with dates and times have always been my weakness. I am trying to calculate how much time between a certain event (ie Date.Now) until the next "certain" time (ie 01:00:00). I have searched and searched but maybe I am just not grasping what I have seen. I am after a

Manage user input -
After doing some extensive searching it is obvious that VB.Net cannot lock input controls as VB6 could and there is no apparent quick fix... Does anyone know whether there is a way to disable a panel or group box in VB.Net without sacrificing the appearance of the contents of the pane

Set Enable -
Hi Everyone, I have three option buttons inside of a frame along with two Date Picker controls. This is what I am trying to do. When the first or second option buttons are selected I want to have the Date Pickers' enabled functions set to false. When the third option button is se

Date/Time -
I can get the current date and time using DATE() and TIME(). They return 4/27/2006 for Date and 9:08:44 AM for Time. What I need to do is convert this to 4272006 for Date and 090844 for Time. The Time needs to be 24hr format. Any suggestions??

crystal report calculating time difference -
I am calculating time difference of employees based on the TimeIN and TimeOUT against the schedule of the employee My Time In formula works fine but only if the employee is late and not if the employee reports earlier than the scheduled time local TimeVar t1 := Time({EmployeeS

Selecting date range in SQL Server with (dd/mm/yyyy HH:mm:ss) datetime format -
Hi I am busy developing an app to extract data from a SQL server table, I have 2 date time pickers, the user selects the date/time they want and when they click a button the selected records are exported to a CSV... Thats what is supposed to happen, however when I use the follo

Help on: Access 97, is there anyway to have just a Date datatype instead of Date/Time -
Please reply as soon as you can, hope someone has the solution. Good morning, is there anyway to patch or installe a plug-in or something into Access 97 so that it can have a Date only data type and not Date/Time. I need only the Date because if I use Date/Time and export a recordse

Time from a DateTime in Dataset -
I have a database with a date/time field. I have no use for the date, though I suppose I could include it just for grins. However, what I need is the time. Therefore, I put the time only into the database field. This works nicely, and when I look at the table, I see the time. Howeve

Kind of a brain fart -- No actual code involved -
I was just wondering, for those of you who have worked with databases a lot; how should I organize this? I have this form. And when you select a # from the combo box (1-15) it displays some date time pickers, and you enter a date. I also have this table. This table has the follo

calculating hourly means -
Hello, I have a excel file in the following format: Column A=date Column B=time Column C=time rounded Column C=temperature I have a series of temperature measurements at irregular intervals. I have figured out how to round the time to the nearest hour (time rounded) and now I

System Time Vs Timer help -
Hi i'll just started a new program. The program i have need to show the form starting time and update the time in a label in the background while the user uses other function on the program like calculating functions, login / search section etc... The program need to record the

Help with Year to Date & Month to Date Stats -
I have an Access dB that my frontend is populating. I have created pre-defined Excel templates for report generating. Now each line-entry into the dB is date-stamped, what I need is how to go about calculating the Month-to-Date, and Year-to-Date stats from the daily data in the dB.

a simple update command no longer working -
*edit because I reversed the 2 sets of code and explain better.....* I did my database on my machine and everything was working. I then went to go run it from another machine and now this one command wont work. I load up my database from a week ago when i know it worked and it still