# Cakephp3 date\_format error: Call to a member function format() on boolean FrozenTimeTrait.php

**URL:** <https://discourse.cakephp.org/t/cakephp3-date-format-error-call-to-a-member-function-format-on-boolean-frozentimetrait-php/4563>\
**Category:** Need Help\
**Created:** [July 12, 2018, 11:44am UTC](https://discourse.cakephp.org/t/cakephp3-date-format-error-call-to-a-member-function-format-on-boolean-frozentimetrait-php/4563 "2018-07-12T11:44:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bichomen](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/bichomen/32/1070_2.png) [@bichomen](https://discourse.cakephp.org/u/bichomen)\
**Post date:** [July 12, 2018, 11:44am UTC](https://discourse.cakephp.org/t/cakephp3-date-format-error-call-to-a-member-function-format-on-boolean-frozentimetrait-php/4563/1 "2018-07-12T11:44:50Z")

</div>

**fnacimiento** and **ffallecimiento** is date in the table

```
$personas = TableRegistry::get('Personas')->find();
$personas = $personas->select([
              'fnacimiento' => 'date_format(fnacimiento, "%d/%m/%Y")',
              'ffallecimiento' => 'date_format(ffallecimiento, "%d/%m/%Y")']);
$this->set('personas', $personas);

```

I want to move from `0000-00-00` to `00/00/0000 (YYYY-MM-DD to DD/MM/YYYY)`

But it is not working it gives me this error:

> Error: Call to a member function format() on boolean File …vendor/cakephp/chronos/src/Traits/FrozenTimeTrait.php Line: 161

The query is fine, because in mysql it works, but cakephp has some problem with the format, I do not understand it.

---

<div class="post-metadata">

**Author:** ![Diego](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/diego/32/296_2.png) [@Diego](https://discourse.cakephp.org/u/Diego)\
**Post date:** [July 12, 2018, 12:07pm UTC](https://discourse.cakephp.org/t/cakephp3-date-format-error-call-to-a-member-function-format-on-boolean-frozentimetrait-php/4563/2 "2018-07-12T12:07:55Z")

</div>

in .ctp  
`echo $persona->fnacimiento->format('d/m/Y');`

or change the app config format  
in config/bootstrap.php

> Type::build(‘date’)-\>useLocaleParser()-\>setLocaleFormat(‘dd/MM/yyyy’);  
> Type::build(‘datetime’)-\>useLocaleParser()-\>setLocaleFormat(‘dd/MM/yyyy HH:mm’);  
> Type::build(‘timestamp’)-\>useLocaleParser()-\>setLocaleFormat(‘dd/MM/yyyy HH:mm’);

---

<div class="post-metadata">

**Author:** ![bichomen](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/bichomen/32/1070_2.png) [@bichomen](https://discourse.cakephp.org/u/bichomen)\
**Post date:** [July 12, 2018, 1:16pm UTC](https://discourse.cakephp.org/t/cakephp3-date-format-error-call-to-a-member-function-format-on-boolean-frozentimetrait-php/4563/4 "2018-07-12T13:16:31Z")

</div>

Thank you!!

I tried to do:

`$fncimiento->format('d/m/Y');`

But I was wrong, when doing:

`$fncimiento = $fncimiento->format('d/m/Y');`

it worked without problems