CF is most probably using a US dateformat (depends on the settings of your server).
TRY: <cfset targ=#CreateDate("2001","12","01")#> <cfoutput>#Dateformat(targ,"dd/mm/yyyy")#</cfoutput> <cfset compare=DateDiff("d",targ,Now())> Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -----Original Message----- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: dinsdag 4 december 2001 13:22 To: CF-Talk Subject: I hate DateDiff! Hi, No matter what I try this will not work for me. Can anybody point out what is wrong with this code. <cfset targ=#DateFormat("01/12/2001","dd/mm/yyyy")#> <cfoutput>#targ#</cfoutput> <cfset compare=DateDiff("d",#targ#,#DateFormat(Now(),"dd/mm/yyyy")#)> It gives me weird output dates - of -233. Thanks, Declan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists