Laravel form :: date function format

Question

I need your help with something. I cant find to work this one out. I think it should be really simple, but it has kept me busy for hours.

{{Form::date('age', $data[0]->age)}}

When I use the form::date function I let a user select a birthday. After selecting the information is saved to a database in the following format ("Y-m-d"), this works perfectly.

If the user wants to edit the date of birth, it shows it as ("d-m-Y"), how can I show this as ("Y-m-d")? I have been searching online for hours, have tried it with carbon, with date_format and a lot more, nothing seems to work.

What am I doing wrong here? I am using laravel 5.2

Thank you for the help.

UPDATE

The query to get the information from the Mysql panel:

$userId = auth()->user()->id; 
$data = Setting::where('user_id', '=', $userId)->first(); 
return view('pages_user.mysettings')->with('data', $data);

The model:

protected $dates = ['age'];
protected $table = 'date_userinfo';

The input box

{{ Form::date('age', $data->age->format('Y-m-d')) }}

A date of birth in the output as ("Y-m-d"), for example 1988-12-31 — Wesley Schravendijk
– Wesley Schravendijk, Commented Jul 11, 2018 at 1:54

ahinkle · Accepted Answer · 2018-07-11 03:05:22Z

2

Try this:

{{ Form::date('age', date('Y-m-d', strtotime($data[0]->age))) }}

It will convert date into Y-m-d format.

I would strongly recommend checking out Carbon. It's built in with Laravel and works well with dates.

Update: In your Model set:

protected $dates = ['age'];

Then, in your view :

{{ Form::date('age', $data[0]->age->format('Y-m-d')) }}

Also, I wouldn't recommend using $data[0] to get the data. If it's multiple rows, use a foreach, otherwise you can pull one record (instead of multiple) by using ->first() in your query.

Edit: Workaround but forces it to work as long as the date format is d-m-Y

{{ Form::date('age', \Carbon\Carbon::createFromFormat('d-m-Y', $data->age)->format('Y-m-d') }}

edited Jul 11, 2018 at 3:05

answered Jul 11, 2018 at 1:59

ahinkle

2,2814 gold badges34 silver badges59 bronze badges

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

17 Comments

Wesley Schravendijk Over a year ago

I tried this one, didn't changed the output. It still shows as ("d-m-Y")

ahinkle Over a year ago

Where is your $data coming from? Are you pulling from a model?

Wesley Schravendijk Over a year ago

I am pulling it from the controller, straight from the MySQL database, the row is called age with a datatype of date. If I would only echo the $data[0]->age, it shows a correct date as ("Y-m-d").

ahinkle Over a year ago

Ok. Do you have a model configured? Say, I have a table called users, I should have a User model setup and I would pull data via $users = Users::get(). Once you have this you can tell your model which column contains dates and it will automatically format it for you.

Wesley Schravendijk Over a year ago

I found the solution to the problem. Laravel wasn't the problem, google chrome is! As I use English, it automatically converts it, when I, for example, would change to Japanese, it shows it the right way. Google chrome; changes it.

|

Wesley Schravendijk · Accepted Answer · 2018-07-12 06:49:53Z

0

The problem is google chrome, not laravel. Google chromes changes the date to the local standards.

answered Jul 12, 2018 at 6:49

Wesley Schravendijk

4952 gold badges6 silver badges25 bronze badges

Collectives™ on Stack Overflow

Laravel form :: date function format

2 Answers 2

17 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

17 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related