>Andy Mcshane wrote: >> my date fields are stored in my database in the format YYYYMMDD. I have > >first off why aren't you using standard sql datetime datatypes? > >> #lsdateformat(mydate, "YYYYMMDD")# produces this error "31 Dez 2004" is > >maybe give lsParseDateTime(date/time-string) a spin.
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, <cfprocparam type="IN" value=#lsdateformat(mydate, "DD MMM YYYY")# cfsqltype = CF_SQL_DATETIME [EMAIL PROTECTED]> This is what produces the error message above. I am unfamiliar with LSParseDateTime, what does this actually do? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:184115 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
