datetime\date not working on Reports

[pmontanez]

Good Day guys,

I've been trying to recreate a Birthday report as posted on EspoCRM blog a few months ago, now we follow all the details but it does not seem to be working - I recreate the same scenario on the Espocrm Demo environment with the same negative results. Now when I use the Month function it works as intended.

Can you please take a look and advise.

Thanks,

[yuri]

Hi,

It's a bug. We will fix it.

You can fix it in your instance by changing line

https://github.com/espocrm/espocrm/blob/master/application/Espo/ORM/DB/Query/Base.php#L257

to
$function = 'DAYOFMONTH';

[pmontanez]

yuri Works as intended with above fix - Thanks