Sethm Posted January 7, 2010 Share Posted January 7, 2010 I am trying to sort my fields by Date (the date they were sold/closed). Issue: The way they have been inputting date isn't into a date field. I need them to be inserted into a date field (so they have a 0 in front of the 1 in January for instance so the Sort field will sort them properly). However, I can't get them to input it in the correct format without irritating my customer (making them input YYYY-mm-dd). They are used to inputing the date as m/d/Y - but the format required for Date cells is as you know Y/m/d. If I had it in that format I believe it would sort my fields correctly - but I can't get it to explode the cells correctly and input it into the Database correctly (if at all) ... The output I have figured out...but this input part is frustrating me ..to no end! Help PHP Freaks! You are my only hope! Thanks! Seth Quote Link to comment https://forums.phpfreaks.com/topic/187600-input-date-in-database/ Share on other sites More sharing options...
wildteen88 Posted January 7, 2010 Share Posted January 7, 2010 Maybe this article will help you working with dates in PHP/MySQL. Quote Link to comment https://forums.phpfreaks.com/topic/187600-input-date-in-database/#findComment-990467 Share on other sites More sharing options...
Sethm Posted January 7, 2010 Author Share Posted January 7, 2010 Excellent - just where I needed to be pointed! Thank you for the help!! Hope you have a great day! (Mine just got better!) Seth Quote Link to comment https://forums.phpfreaks.com/topic/187600-input-date-in-database/#findComment-990487 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.