Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Airtable AI
Airtable Enterprise Network
Marketing
Product Operations
EDUser Group
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
kcs-it
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
kcs-it - profile
kcs-it
4 - Data Explorer
since
May 17, 2023
May 18, 2023
User Statistics
1
Posts
0
Solutions
0
Kudos given
0
Kudos received
View all badges
User Activity
Posts
Replies
No posts to display.
Re: Calculation for birthday - off by 1 day or not date formatted
May 17, 2023
This is based off @Ben_Young1's solution. I don't know why the function subtracts a day, it doesn't seem to be a timezone issue. I used DATEADD() to add a day. Hopefully it'll work for you.IF( {DOB}, DATETIME_PARSE( DAY(DATEADD({DOB},...