Andy Mcshane wrote: > I am using the standard SQL datetime datatypes, The way I wrote it above is > just to simply demonstrate the way the SQL stores the date. I handle all of > my database access using stored procedures so I use CFStorerdProc & CFProcParam so I what I actually try to pass out to SQL is this,
no, that's not how sql server stores dates. refer to your BoL. > value=#lsdateformat(mydate, "DD MMM YYYY")# you've made up your own date format. in i18n work it's ALWAYS a good rule to use standard date formats (standard as in java style), which MX also uses (for de_DE locale): "full" Samstag, 13. November 2004 "long" 13. November 2004 "medium" 13.11.2004 "short" 13.11.04 these should be understandable to users & easily parsed (and if not, you can always blame sun). making up your own date formats requires actual locale research & for me, too much programming. and if you're doing this w/out doing any locale research, well.... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184197 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
