close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Date Format with DataAssist

Thread began 8/06/2009 8:42 pm by reneas.email303886 | Last modified 8/18/2009 7:15 pm by Eric Mittman | 4063 views | 12 replies |

reneas.email303886

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'

Sign in to reply to this post

reneas.email303886

DataAssist Date Format Not Solved

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'

Sign in to reply to this post

Intrigue25

Date Formated

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.

Sign in to reply to this post

reneas.email303886

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:)

Sign in to reply to this post

reneas.email303886

Date Format Question Cont...

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'

Sign in to reply to this post

Brad Lawryk

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

Sign in to reply to this post

reneas.email303886

Validation Kit, Etc. Response

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'

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

reneas.email303886

Date Format Question Cont...

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'

Sign in to reply to this post

reneas.email303886

Date Format Resolved

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

Renee'

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...