I am having a problem with erroneous MINUTES in my DateTime
creation/formatting.
The rest of the DateTime comes out correctly. >>> LINK <<<
OUTPUT ...
Date Formatting tests
vStartDate = 01/01/2000 vEndDate = 14/4/2009
CreateDateTime (vStartDate) = {ts '2000-01-01 00:00:00'}
DateFormat of the above = 2000-01-01 00:01:00
CreateDateTime (vEndDate) = {ts '2009-04-14 23:59:59'}
DateFormat of the above = 2009-04-14 23:04:59
AFFECTED CODE ...
<CFset vDate = CreateDateTime(vStartYear,StartMonth,StartDay,00,00,00) />
<CFset vStart = DateFormat(vDate, "yyyy-mm-dd HH:mm:ss") />
<CFset vDate = CreateDateTime(vEndYear,EndMonth,EndDay,23,59,59) />
<CFset vEnd = DateFormat(vDate, "yyyy-mm-dd HH:mm:ss") />
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12962 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4521
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
