Use the DateAdd function. Don Whitehead Developer/DBA INCCRRA Microsoft Certified Professional [EMAIL PROTECTED] (309) 829-5327 ext. 28
-----Original Message----- From: Chris Janz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:13 PM To: ActiveServerPages Subject: handling date operations real quick easy one for you guys. i need to pull a date out of the database: rsOut.Fields.Item("thisdate").Value then i need to add 14 months to it to get a new date. i thought about trying Cdate(rsOut.Fields.Item("order_date").Value) + 14 months or something like that... will i have to split the date into it's parts and then add the months manually, or is there just a basic addition operation i can perform on a date? i really don't want to roll over the years, watch for leap years and 31st's that don't exist and all that - it would take nearly 100 lines of code just to add the date! thanks, chris --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
