Just use Date add but using the arguments h,n or s. :)
dateadd("h",1,datevar) adds 1 hour
dateadd("n",30,datevar) adds 30 minutes
Chung
<QT>-----Original Message-----
<QT>From: Eli Shechter [mailto:[EMAIL PROTECTED]]
<QT>Sent: Monday, July 31, 2000 7:49 AM
<QT>To: [EMAIL PROTECTED]
<QT>Subject: Time add
<QT>
<QT>
<QT>Is there a function to do the adding with time. (like DateAdd)
<QT>i want to create a output with the hours of the day by the
<QT>half hour.
<QT>
<QT>meaning:
<QT>
<QT>8:00
<QT>8:30
<QT>9:00
<QT>9:30
<QT>
<QT>does anyone know of a way to do this??
<QT>
<QT>Thanx
<QT>-Eli-
<QT>
<QT>------------------------------------------------------------
<QT>------------------
<QT>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
<QT>To Unsubscribe visit
<QT>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
<QT>sts/cf_talk or send a message to
<QT>[EMAIL PROTECTED] with 'unsubscribe' in the body.
<QT>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
