Upcomig birthdays calender

AppSheet AppSheet Q&A
1

I have column name [Date of birth]. Now I want a calendar view showing the current month’s birthdays.

I have created a virtual column using DATE(DAY([Date of Birth])&“-”&MONTH([Date of Birth])&“-”&YEAR(NOW())) but this is not working for all row.

I need a better idea.

debajyoti_0-1658236643797.png
debajyoti_0-1658236643797.png961×158 5.48 KB

2

Does it have to be a calendar view? If it does, then you can just link to a calendar and show that inside your app like this

Alternatively, if you want to keep the data in your tables, you could just create a slice that selects the records within x period of time using TOP() and display them as a deck?

3

Your idea of taking day and month and add current year look great, just consider that you are trying to create a date on the “dd/mm/yyyy” format and afaik Date() expects it to be on the “mm/dd/yyyy” format, which is why you find it “not working for all row” so I’ll bet it’s working when the actual Day is less than 13 so it get’s interpreted as a Month by Date(). Just switch your DAY() and MONTH() expressions, something like this:

DATE(
 CONCATENATE(
  MONTH([Date of Birth]),
  "/",
  DAY([Date of Birth]),
  "/",
  YEAR(TODAY())
 )
)

You could also consider to add a more strong method considering that each December you won’t be able to see the birthdays for the next months

2 Likes
4

Thank you very much. Actually I already sorted this out by changing date format. And I need to see birthdays for current month so this could be okay for me.

1 Like