2 Replies Latest reply on Jan 8, 2009 6:41 PM by Dan Bracuk

    CreateODBCDate and cfqueryparam with cf_sql_date

    Level 1
      Hi all.

      I've got a form that's accepting the following date formats (YYYY-MM-DD and MM-DD-YYYY).

      Just wondering if it's even necessary to use the CreateODBDate when I'm passing in the dates in my <cfquery> using a queryparam with a type of cf_sql_date?

      From what I understand cf_sql_date will recognize either of the two formats and properly create the ODBC date the way it's supposed to, but I can't find any resources that says this. Anyone know this for sure or not, and maybe have a reference I can point my team in the right direction?