Pascal, Thanks very much for your help.Was going around in circles with that one.
Regards, Declan -----Original Message----- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: 04 December 2001 12:30 To: CF-Talk Subject: RE: I hate DateDiff! 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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