Meh, no worries mate! ;o) I was going to suggest that you write a UDF that would handle it the way you expect, but then I thought that's probably more trouble than it's worth. :o)
Cheers, Chris Jacob Munson wrote: >> The problem is that you cannot give the CreateDateTime function a '5' >> and expect it to know if you mean AM or PM. The function works only with >> a 24 hour clock. pass it a seventeen (which your second case does since >> hour(now()) equals 17 not 5), and everything works fine. >> > > I guess I missed the part in the docs that says the 'hour' part of > CreateDateTime is 24 hour. :) > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
