Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (2)

Resolved How to show a current birthday module?

  1. chap
    chap
  2. Support
  3. Tuesday, May 30 2017, 11:33 AM
Hi there,

I want to show a list of members in a module who have today them birthday. I have a birthday field in use. What to do?
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
you can create a module of type "Easy Profile - Users List" and set parameter "Custom SQL Where" to:
DAY(dob) = DAY(CURDATE()) AND MONTH(dob) = MONTH(CURDATE())


Replace "dob" with alias of your birthday field
  1. more than a month ago
  2. Support
  3. # 1
chap
chap Accepted Answer
Great, it works!

Thanks
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.