Do this #createodbcdatetime(createDate(mid(form.datelisted, 7, 4), mid(form.datelisted, 4, 2), mid(form.datelisted, 1, 2))#<
Dale -----Original Message----- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Gavin Baumanis Sent: Wednesday, 20 July 2011 12:05 AM To: cfaussie Subject: [cfaussie] MySQL - date insertion issues. Hi Everyone, I have the following code; form.date : #form.datelisted#<br /> LSDATEFORMAT : #lsdateformat(form.datelisted, 'YYYY-MM-DD')#<br /> DATEFORMAT : #dateformat(form.datelisted, 'YYYY-MM-DD')#<br /> CREATEODBCDATE : #createodbcdate(form.datelisted)#<br /> CREATEODBCDATETIME : #createodbcdatetime(form.datelisted)#<br /> Which outputs the following; form.date : 01/03/2011 LSDATEFORMAT : 2011-01-03 DATEFORMAT : 2011-01-03 CREATEODBCDATE : {d '2011-01-03'} CREATEODBCDATETIME : {ts '2011-01-03 00:00:00'} My question is why are my month and day parts of my date being transposed? How do I stop it from being so? The date that should be inserted into the database is the 1st of March, not 3rd January. As always - Thanks! Gavin. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.