Announcement

Collapse
No announcement yet.

datetime\date not working on Reports

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • datetime\date not working on Reports

    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,
    Note: This feature is available since EspoCRM 4.7.0 and Advanced Pack 1.22.0. Assume that we have the field dateOfBirth in Contact entity. 1. Create new list report for Contacts. 2. In the filter section click Add Complex Expression and specify fields like on the screenshot.

  • #2
    Hi,

    It's a bug. We will fix it.

    You can fix it in your instance by changing line
    https://github.com/espocrm/espocrm/b.../Base.php#L257
    to
    $function = 'DAYOFMONTH';

    Comment


    • #3
      yurikuzn Works as intended with above fix - Thanks

      Comment

      Working...
      X