Show next birthdays in calendar

[pmontanez]

Hey tanya sorry I didn't notice your message - Bug was resolved on 5.01 - By the way nice profile picture!

[tanya]

Hello
Show me, how you define your report, please

[pmontanez]

Thanks for above, still not working - I recreate the datetime\date function on the Espocrm Demo environment with the same negative results - I just reported as a bug - thanks

[SebastianZ]

Hi,

try datetime\today()

greets

[pmontanez]

Good Day,

I've been trying to make this to work but not sure what am I doing wrong. I need to create a daily report list that shows "today's" contacts birthday, I'm using the function suggested above datetime\date(datetime\now()) but that not work, Now if I use Sebastian function datetime\format(datetime\today(),null,'MM') I could get a list of contacts with birthdays in current month or next month etc,

Any Ideas?

Thanks,

[SebastianZ]

Awesome!!! Thx for great support.

[yuri]

Both filters must be under OR group. See https://github.com/espocrm/documenta...ts.md#or-group

[SebastianZ]

If I take twice the same expression "or" combined it works.

If I use each expression separate, it each works (each expression has 1 result: 1 contact with birthday in may, 1 contact with birthday in june)


datetime\format(datetime\today(),null,'MM')
datetime\format(datetime\addMonths(datetime\today( ),1),null,'MM')

But if I use them "OR" combined I expected to have 2 result but I get none.

[yuri]

It's unlikely that there is no datetime\month in your version. It's not available in UI you just need to type in manually.

You can post a screenshot of your filters. It's unlikely that there is a bug but anyway need to check.

[SebastianZ]

Thx for reply, tested it but the is no function datetime\month in my version....

so I tried an other way to achive this I used this:

datetime\format(datetime\today(),null,'MM')

which works well but i want the birthday of this month and next month too

so I add an OR filter with the following expression

datetime\format(datetime\addMonths(datetime\today( ),1),null,'MM')

but no result....

If I tried only the birthday from the next month, it works well to, but OR combined no result. This might be a bug I think.

[tanya]

Hello

Good news

Version 1.22.0 released

* Report: Ability to specify complex expression with functions as a filter (only with EspoCRM 4.7.0 and greater).
* Report: Supporting foreign date, datetime and image fields as columns in list reports.
* Workflow: Fixed not properly working conditions w/ Link Multiple fields.

Now it's possible to create more complex filters in reports. E.g. showing contacts having birthday today, the next months etc.

https://www.espocrm.com/blog/report-...have-birthday/

[SebastianZ]

Thx, that are good news.

[tanya]

hello
For now it is possible only, if day, month, and year are in separated fields. A little bit later it will be possible with one date field

[SebastianZ]

Sorry for beeing annoying but I didn't find a way to filter a list report to the todays bithdays or maybe the birthdays in the next week, could you please give me an advice?

[SebastianZ]

That's clear! My problem is the report, I don't see a way to filter contact that have birthday today. This only works in grid reports but I think I need a list report.