> then its just the following piece of code that doesnt work: > > <cfset dateOfBirth = lsdateformat(queryName.dateofbirth,"dd/mm/yyyy")> > > it 'spits' out the error stated above 'invalid date format 01/16/1990' > > it is saved in the db as 1990/01/16, im not telling it to put > it in the format 01/16/1990, i am telling it to put it in the > format 16/01/1990 > > if i put exactly the same code but take out the ls then it works fine > > <cfset dateOfBirth = dateformat(queryName.dateofbirth,"dd/mm/yyyy")>
Have you set your locale? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4