cant change date format posted in form in PHP from mm/dd/yyyy to dd/mm/yyyy

Question

I know this question has been asked before but none of the solutions is working for me, I have got a form in which the user enters the date of birth, but for reason it is set to mm/dd/yyyy and I want to change it to dd/mm/yyyy. As soon as i enter the date like 19/12/1992 it prompts invalid date format.

The code in the form is :

<label for="name">Date of Birth (mm/dd/yyyy) <font color="red"> *</font></label> <input type="text" name="DOB" value="<?php echo $info['DOB']; ?>" onfocus="$(this).removeClass('date required')" onchange="$(this).addClass('date required')" required />

And the code in the function after POST is:

$DOB = mysql_real_escape_string($_POST['DOB']);

Suchit kumar · Accepted Answer · 2014-09-30 10:32:45Z

1

EDITED: use this:

1)

 $DOB = mysql_real_escape_string($_POST['DOB']); $newDate = date("d/m/Y", strtotime($DOB));

OR

2) $newDate = DateTime::createFromFormat('m/d/Y', $DOB)->format('d/m/Y');

edited Sep 30, 2014 at 10:32

answered Sep 30, 2014 at 9:18

Suchit kumar

11.9k3 gold badges26 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user3297381 Over a year ago

thanks a lot, but now it is not saving the value, it is saving a date 01/01/1970

Suchit kumar Over a year ago

@user3297381 see this: stackoverflow.com/questions/8984595/…

Suchit kumar Over a year ago

may be the format you are trying to conver is unsuported by strtotime.

Suchit kumar Over a year ago

@user3297381 can you try the second option and see.

Kelvin Kehinde Omolumo · Accepted Answer · 2014-09-30 09:34:38Z

Like they all said do this

 $DOB = mysql_real_escape_string($_POST['DOB']); $newDate = date("d/m/Y", strtotime($DOB));

Then at the other side where you are either inserting or updating the database change the date back to mysql standard format like this:

$DOB_DB = mysql_real_escape_string($_POST['DOB']); $DOB_DB = date("m/d/Y", strtotime($DOB_DB));

It worked this way by reverting the format back, thanks a lot !!

JoelP · Accepted Answer · 2014-09-30 09:22:49Z

0

You could use strtotime:

$oldDOB = mysql_real_escape_string($_POST['DOB']); $DOB = date("d/m/Y", strtotime($oldDOB));

edited Sep 30, 2014 at 9:22

answered Sep 30, 2014 at 9:17

JoelP

4391 gold badge4 silver badges13 bronze badges

1 Comment

user3297381 Over a year ago

thanks a lot, but now it is not saving the value, it is saving a date 01/01/1970

Collectives™ on Stack Overflow

cant change date format posted in form in PHP from mm/dd/yyyy to dd/mm/yyyy

3 Answers 3

4 Comments

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

1 Comment

Linked

Related