Date Format with DataAssist

Question:

I have a column in my table and the datatype is DATETIME. I need it to display the date in this format 08/03/2009 with DataAssist. Can someone, pls tell me how to do this? Thanks!

Renee'

Originally Said By: reneas.email303886

  Question:

I have a column in my table and the datatype is DATETIME. I need it to display the date in this format 08/03/2009 with DataAssist. Can someone, pls tell me how to do this? Thanks!

Renee'  

Forum:
Please anyone with info..I am sure I am not the first person looking to format the date using DataAssist or Validation Kit. Can someone please assist me asap thanks!

Renee'

Renee'

If you using PHP. Where the info si displayed on you page modify it to read like this

<?php echo date("m/d/Y", strtotime($row_recordsetName['columnName'])); ?>

this should format if for you.

Originally Said By: Intrigue25

  Renee'

If you using PHP. Where the info si displayed on you page modify it to read like this

<?php echo date("m/d/Y", strtotime($row_recordsetName['columnName'])); ?>

this should format if for you.  

Will give it a go...thank you:)

Date format correct on Results.php page; however, I need to figure out how to format the text field on the Insert.php so when someone types they type the date as follows: 08/07/2009? Any help appreciated. Thanks!

Renee'

Originally Said By: reneas.email303886

  Date format correct on Results.php page; however, I need to figure out how to format the text field on the Insert.php so when someone types they type the date as follows: 08/07/2009? Any help appreciated. Thanks!

Renee'  

I beleieve both the WebAssist Validation tools and the Spry Validation in Dreamweaver will do that for you.

Brad

Brad:

I selected form in Insert.php then choose Behaviors and choose my date field in the form and selected the date format I want the Validation Kit to format it to, but it does not work? When someone types the date, shouldn't it format the date as they type it or on submit?

Anyone that can assist me further pls holler thanks!

Renee'

When you use the client side date validation it will allow you to select the appropriate format for the date and also has an option to reformat the date to the type you desire. This reformating is done when the form is submitted and the validations run.

The server side validation for the date is just to ensure the user enters it in a particular fashion, you can use this and a validation show if to display a message to the user to indicate the format the date must be entered.

Like Brad mentioned I think spry also has this type of validation.

Eric:

Okay I have since attempted to do it with Spry and while the formatting is better, it's still not in the correct format when someone types in the text field on the Insert.php? Currently the date looks like this in Results.php:

2009-08-07

which is better but it should look like this 08-07-2009 for the person filling out the Insert.php form and then when the Results.php page displays the info I want it to look exactly the same. Can someone please assist me further...I am open to remote support. Thanks!

Renee'

Got it to work with Spry Validation thanks all for your help:)

Renee'