|
|Is there a way to fill in a future date in a column of
|a table?
Use the dateadd function with the now() fuction as an argument to specify a
future date
ex.:
2 weeks from today:
#DateAdd("d","14",Now())#
make sure the number of "days" is in quotes.
Regards,
Anthony Geoghegan.
Lead
Look at the DateAdd function
http://127.0.0.1/cfdocs/CFML_Language_Reference/3_ColdFusion_Functions/lr3_068.htm
--K
Katrina Chapman
Consultant
Ameriquest Mortgage
Use the dateadd function
cfset tomorrow = dateadd("d",1,now())
Tomorrow is #tomorrow#
Add or subtract any date or time with the same fuction and differing
parameters.
--
Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000
a table?
I am familiar with the
Sure. Look up the date functions in Cold Fusion. I would use the following
syntax:
CreateDateTime(year, month, day, hour, minute, second)
then embed the DateAdd function for each element.
#CreateDateTime(DateAdd('', 1, Now()), DateAdd('M', 1, Now()),
DateAdd('D', 1, Now()), DateAdd('H',
4 matches
Mail list logo