RTFM? steady on ol' chap. it's because of the manual that I've been having
this headache.
1) how do you get that date object from a form (string)?
a) CreateDate(year, month, day)? perfect for 3 list boxes but I want to
use ISO dates because every decient db understands the format and can't
screw it up. As I said in my origional email, tearing the date string
apart is one way people do this BUT (imho) IT'S A CRAP IDEA. I never had
to worry about this with ASP. Tear it apart to put it back together?
madness...
b)CreateODBCDate(date)
Parameter: date
Description: Date or date/time OBJECT in the range 100 AD-9999 AD
- nope, can't use. I've got a date STRING, or so it seems...
c) ParseDateTime(date/time-string [, pop-conversion ] )
looks promising!
Return value: An English (U.S.)-formatted date/time value.
rats! no ISO date.
OR LSParseDateTime(date/time-string)?
sorry, no ISO date masks supported
2) since CF is an untyped language, the "date/time object" is simply a
string in a particular format ( {ts '2003-07-06 00:00:00'} ). I'm trying
to avoid
3) change the function to choke on strings? yeah, I see your point but can
you see mine that Dateformat didn't choke but LSDateFormat did?
As it turns out, I am getting LSDateFormat to work using an ISO date,
although you've now sown seeds of doubt that it is truly working.
<cfset form.date = "1996-01-01">
<cfset objDate = LSDateFormat(form.date, "yyyy-mm-dd")>
<cfquery ...>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
