Date type related task / extensions

Hi,

I have one general question for DataBridge and Date type related tasks.
Are all Date related tasks like Date search or Datepicker etc. compatible with mysql databases date format?
I have been reading Date type (US standard mm-dd-yyyy) but the database always uses yyyy-mm-dd format.

Does is still need handcoded date conversions or can above tasks already insert the correct format to the database, eventually display any other custum format?

Thanks.

The wizard will automatically convert the date format for you whenever your field datatype is set to be a date.

If you use the server behaviors manually, then you can convert the date format using php... so to display the date from a database use:

<?php echo(date('m-d-Y',strtotime($row_recordset['datecolumn']))); ?>

and to insert from a form field use:

<?php echo(date('Y-m-d',strtotime($_POST['FormField']))); ?>

That way you can display whatever format you want to use and it will store and retrieve the correct format from the database.

Thanks Ray,

I'm tring to read as much as possible regarding the new DataBridge / DataAssist.
I will purchase this new extension as well but will wait untill the minor bugs are fixed (to save installation time).
Also i can't wait to see some upcoming tutorials based on the new extension DataBridge.
I truly believe you made some great improvements and would love to see them in action!