I know that date format will guess what format you have entered the date in if you don't give it a valid date object but i always find it more reliable to first create a valid date then try formatting it
e.g.g http://www.openbluedragon.org/manual/?/function/createdate then date format Regards Alex On 6 November 2011 19:08, Rogerio Pereira <[email protected]> wrote: > Hi, > > I tested the following code in OpenBD (JDK 6) and I get a strange > return. > > <cfset Data = "10/16/2011"> > <cfoutput>#DateFormat(Data,'dd/mm/yyyy')#</cfoutput> > > It returns the following error: > > Data not supported: Invalid date/time string: 10/16/2011 > > But the following code works fine: > > <cfset Data = "10/15/2011"> > <cfoutput>#DateFormat(Data,'dd/mm/yyyy')#</cfoutput> > > <cfset Data = "10/17/2011"> > <cfoutput>#DateFormat(Data,'dd/mm/yyyy')#</cfoutput> > > I am running pt-BR Locale. > > Any ideas? > > Thanks in advance. > > Rogerio > > -- > official tag/function reference: http://openbd.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
