Well if you copied the code exactly here you are missing a )
<CFSET Today = Dateformat(Now(), "mm/dd/yy">
should be <CFSET Today = Dateformat(Now(), "mm/dd/yy")>
Kevin Schmidt wrote:
>
> Ok...either I am doing something stupid or something is wrong here.
>
> This is on CF 5.0
>
> I am using <CFSET Today = Dateformat(Now(), "mm/dd/yy"> and then inserting
> today into a database table. I end up with 12/31/1899.
>
> Here is the really tricky part. After that date is set I use DateAdd to add
> a month to it and insert it into the database at the same time as the other
> and I get the correct date. Any ideas.
>
> By the way I changed the today code to <CFSET Today = CreateODBCDate(Now())>
> and it is fine. But I am still curious as to why the other way was
> producing that result???
>
> Kevin Schmidt, Web Technology Manager
> Allaire Certified ColdFusion Developer
> pwb inc.
> integrated marketing communications
> 350 S. Main St., Suite 350
> Ann Arbor, MI 48104
> 734.995.5000 (tel)
> 734.995.5002 (fax)
> www.pwb.com
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
