close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Displaying date as dd-mm-yyyy and inserting to MySQL DATETIME field?

Thread began 5/27/2014 11:34 am by Nathon Jones Web Design | Last modified 12/28/2015 9:02 pm by Nathon Jones Web Design | 26804 views | 9 replies

CraigRBeta Tester

I would urge you to use the datepicker tool, it is easy to configure and looks nice

- also there are lots of options you can set, like limiting the date range etc, so you should be able set it to default to the current date easily enough.

http://api.jqueryui.com/datepicker/


Re the function, you don't need to change anything

all you need to do is call the function, putting in your date field as a parameter.

the function in question expects an input date in the format dd/mm/yyyy and will produce a date in the format yyyy-mm-dd

so all you need to do is change the line in the update query like so

"".((isset($_POST["LEDProductUpdateDate"]))?$_POST["LEDProductUpdateDate"]:"").""



to

"".((isset($_POST["LEDProductUpdateDate"]))?formatUKDateMySQL($_POST["LEDProductUpdateDate"]):"").""



If your date format in the field is different to dd/mm/yyyy then you will need to change the function which manipulates the string accordingly, whatever the start point is, the result should be in the format yyyy-mm-dd

Hope that helps

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...