Parsing Dates for MySQL
MySQL requires dates in the 2012-08-15 format. I haven't had success using LSParseDateTime to clean dates for insertion, but '#LSDateFormat(query.date, 'yyyy,mm,dd')#' works fine. For numbers and currency #LSParseCurrency(FORM.dollars)# and #LSParseNumber(FORM.number)# work, allowing you to format numbers and currency in the FORM (like 1,344.56 and $535.00) and still insert the values properly in MySQL.

Archives