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

Easy date/time rounding Q. ***RESOLVED*** -

Hi
I'm trying to find the most efficient way of rounding time values to the nearest hour.
Eg "19:41:00" should read "20:00:00"
Any pointers anyone?
Thanks in advance.

 

Easy date/time rounding Q. ***RESOLVED*** -
Hi I'm trying to find the most efficient way of rounding time values to the nearest hour. Eg "19:41:00" should read "20:00:00" Any pointers anyone? Thanks in advance.

rounding (Resolved) -
hi all, im using mediaplayer, a timer, and textbox to display the time of the file. how can i round the time for eg: 29.123456789 sec to only 29.123 sec thanks

Subtracting a time interval from a date time value (RESOLVED) -
I know I am asking something really silly, but I have not got my thinking cap on this issue yet, since there are heavier ones I am preoccupied with, and at these times, the lighter ones slip your mind. I need to subtract a time interval from a date and get the resultant date time .

time and date conversion***RESOLVED*** -
in access i have a date field set as date/time with a general setting in the property box under format. i noticed i can set the property to short date or short time i would like to view the date any way and the time in military when i run my VB application i can see the date and

** RESOLVED ** vbscript, php, mysql, date issue. -
Ok, can't seem to figure this out. I have a mysql database and inside it is a table with two fields.. date[int(10)] and name[text]. The rows are added by a php script that puts the date/time as an integer. The way php handles dates is x amount of seconds since January 1 1970 00:

Disabling Date/Time Option in Taskbar [Not Resolved] -
Hi Guys, Anybody knows what is the registry key to disable the Date/Time, inorder to disallow the people to change the date/time anyway???? Thanks in advance.... Nazeem.

Comparing date of modification for files...(RESOLVED) -
Hi all. I need to compare the date of modification on different files and I was wondering if there was an easy way to verify if a file is more recent then another one. I'm already using the File object which can return a string with the date and time of the last modifications. B

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

**RESOLVED**Crystal Reports Date "" Formula (Easy one i think) -
All I need is a simple date formula that shows the date if a date exists in the table/field. If a date has not been entered in the table/field, I would like it to show as "N/A". Here is the formula I have tried: if {tblPrimDls.PDLine} = "" then "N/A"

Get the Date & Time From A MySQL Time Stamp -Solved[:)]- -
OK, now if i create a record in my table, (mysql) i have a timestamp field, so it fills in like: 20021201214855 Translated To: Date: 01 December 2002 Time: 21:48:55 Now, i know its in the form: YearMonthDayHourMinuteSecond But, is there a way (Already made) That will m

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

**RESOLVED** Rounding to the nearest whole number -
Hi I need help! I have conducted a search on this forum and have found nothing.... what I need help with is rounding to the nearest whole number ??? i.e 1.5 becomes 2.0 1.4 becomes 1.0 etc etc Your help and time is very much appreciated

Rounding Error In Access Report -
Please I need help on how to eliminate rounding errors in Access report. I want the sum of values in Details to be exactly equal to the summation in the Footer. e.g. Name Contribution To-Date David 45,000.00 Samuel 45,000.00 Smith 47,000.00

Syntax error on vb code no one has been able to solve this yet. i am new to this and -
Ihave tryed many different ways to get this to work biyt am still getting sytax errors. Can any find the problem or come up wiyj an alternitive? Private Sub addrecord_Click() On Error GoTo Err_addrecord_Click If Dcount ("[Reservation Date] = " & ReservationDate &a

Displaying time and date * * RESOLVED * * -
How do I display time and date (in real-time) in a label in the following format: May 6, 2004 12:06:32 PM I know this is probably very simple but I can't seem to make it work. Thanks in adavance Brad Nichols

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.

Default Date in SQL Server [RESOLVED with GetDate()] -
How do I set the default value on a DATE field to be the current date/time? Records are currently being written via inline inserts and I'd like to automatically set the time they were entered. (No, I can't switch to SProcs.)

keep from rounding -
I have some formulas outputting to a text box. The numbers keep rounding up. How do I stop this?

Rounding Numbers in VB -
are you rounding or just truncating? your example of 100.956 should round to 100.96 not 100.95 serge's code rounds which is not what your example shows

Rounding up problem vb.net -
Ive been searching the forum for an easy way to round numbers but i couldnt find what i was looking for. lets say if i have a variable and i want to round it up to the closest number so that for example 1.02 = 2, 3.6 = 4, 1.5=2 etc is there any easy way of doing this without lots o

Working with the DATE function -
I need to take Date.Now and get another date by adding 10 days to it. Is there an easy way to do this? Right now I'm doing it the hard way - doing Date.Now.Day + 10 , and then having to check if its over 31 to add a month and subtract, then check again if the month is at the en

Rounding time seconds up in SQL Server -
Have two time values 1900-01-01 00:59:47.000 need to round up to 1900-01-01 01:00:00.000 1900-01-01 00:19:23.000 need to round down to 1900-01-01 00:19:00.000 Perferably using a function or something that does both on the same column! Note the date above is the differenc

File Time&Date -
Trying to wite a program that Will make it easy to transfer a database from one computer to another. What I need is a way to read the file date. Is there a routine to get the file date and Time

Strip time from Time/Date **Resolved** -
Hello, I'm bringing in a time/date stamp in the following format: m/d/y h:m:s am/pm. If one of the m/d/y/h or /m isnt a 2 digit character, it doesnt add a zero to it (ie 9/8/2004 never becomes 09/08/2004). How can I make the time/stamp of "9/8/2004 2:34:24 PM" for exam

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

Changing File Date & Time **RESOLVED** -
I can get the file date and time of a file using FileDateTime(fName). But on certain conditions i need to change the file date and time. Can this be done, if so how? Your help would be much appreciated.... Thanx....

Help: Rounding problem ! -
Hi, I have an application and that give me rare rounding problem. The statement I use to rounding the value x = x + round((w * y), 2) it loop through 4 records, only two record get rounded corrrectly and the other two is not, I have no idea why. Original value Aft

Filename(RESOLVED) -
Any idea where I can custom create the filename using open file command. Here's .... Date = YYMMDD ' The date and time changes everytime Time = X.XX F = FreeFile Open "C:\ & Date & Time &.txt" For Output As #F How to? Thanks **************Tha

[ReSoLvEd] qry to show entries from Today only -
Easy qu.... I can't seem to create a query in MSACCESS showing only the entries entered for the current day? Each new Entry has a datelogged field which defaults to Now() when you start the new record. Therefore it holds date and time info. I can't use now() as the criteria a

Adding Time and/or Date - RESOLVED -
I wish to show the time and date in seperate labels when the splash screen starts - how do I go about this? thanks in advance for any pointers in the right direction.....

Resolved - Date field -
Hi I have a sql table which contains a date field...I have set the formula to getdate() but it seems when I insert a row all transactions date field appear to change.... for example @ 10 I insert a row and the date/time field changes to 16/04/03 10:00 then @ 11 I insert ano

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

MS Access: Dates - finding free time. -
I am trying to come up with a design for a database in access which stores student bookings on driving lessons. One of the requirements is that a query can be ran which will show an instructors free time for a given date range. I am not too sure whether this is possible though. The

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

(Resolved)Auto date in sql table -
I want have auto date in sql table the date field should get updated automatically when a record is inserted only date not time so that i can query on date field

help my numbers are rounding off -
i'm doing a order form, they only problem i am having is my output, all the numbers are rounding off instead of showing decimals, here is my code if someone wants to look at it and tell me what i'm dong wrong, thanks.

Rounding Numbers Within A Textbox -
Hi, Im fairly new to vb.NET, The problem I have is that I want to round a number down instead of it being rounded up. I want to round 10.389 to 10.38 instead of it rounding to 10.39, is this possible? thanks in advance.

Date / Time Calculations -
This is an easy question so it shouldn't take long to answer. I need some code to calculate the number of days, hours, minutes and seconds between a stored date/time and the current system date/time. Can someone help me with this? Example: You have been programming for: "4 Da

Acquiring Create Date before downloading FTP file using iNet control -
I've searched the internet and this seems to be a common problem, but never satisfactorily resolved. I'm trying to get the create date and time of a file before downloading it. The reason is that I need to download a file, the creation and name of which is beyond my control, but wh

insert current datetime RESOLVED -
im trying to insert the current date and time to SQL column i have tried ......,'now()',...... ......,getdate()....... and dim regtime as new date time ........,'regtime'.......... any ideas of how to insert the current date time would be greatly appreciated im a begg