There are many date functions you can use in CF for this. Go to:
Tools/Expression Builder from the menu, then under Functions go to Date and
Time.
-----Original Message-----
From: Jeff W [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 18, 2000 12:10 PM
To: [EMAIL PROTECTED]
Subject: Inserting a date and date manipulation questions.
I need to insert a date into a table for a reminder type application. I am
using Access as my datasource. A user would ask to be reminded in a given
amount of time, say 2 weeks, 4 weeks, etc from the current date. I would
like to put this data in a table for another application to e-mail out
reminders. My sticking point is:
1. how would you insert the current date into the table??
and..
2. how would you insert a future date?? IS there a good source for date
manipulation?? Adding days, subtrackting months, etc...
Thanks
Jeff
[EMAIL PROTECTED]
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
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...
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.