<DIV>I am using a "To String" to create a time stamp and want to subtract three hours from this time and create a new date. So in the event it is 2:00am monday morning, it will output 11:00pm tuesday night. Does anyone know how to manupulate the string to do this, or do I need to do something else?</DIV><p>__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com ---You are currently subscribed to vrf as: rsb@soco.agilent.comTo subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com ---You are currently subscribed to vrf as: rsb@soco.agilent.comTo subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
> the string to do this, or do I need
> to do something else?
Don't manipulate the string - manipulate the date in it's native format
(Real64). Then it's just arithmetic.
now() - hmsToHour(2, 0, 0) = Two hours ago.
See also dmyToDate, hmsToSec, month, wday and year.
NOTE: If you'll be using date values with Excel formulae, check out the many
interesting farkles you'll encounter...
http://www.oswegosw.com/SearchVRF.php?st=time%20conversion
http://www.oswegosw.com/SearchVRF.php?st=epoch
-SHAWN-
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".