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 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. 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 Link to comment https://forums.phpfreaks.com/topic/187600-input-date-in-database/#findComment-990487 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.