I am new to Airtable and Formulas
I saw a post by Florian_Kleinicke
Who said he had managed something similar, could someone please explain how I use the formula below.
DATETIME_DIFF(DATETIME_FORMAT({Birthday},‘MM-DD’),DATETIME_FORMAT(TODAY(),‘MM-DD’...
Justin_Barrett:
IF({Partner Date of Birth}, DATETIME_FORMAT({Partner Date of Birth}, "MMDD")) = DATETIME_FORMAT(TODAY(), "MMDD")
@Justin_Barrett Thanks a million
@Justin_Barrett Just another quick question in the following formula is there a way that if {Partner Date of Birth} is blank it always returns a 0?
DATETIME_FORMAT({Partner Date of Birth}, “MMDD”) = DATETIME_FORMAT(TODAY(), “MMDD”)
this is because if...
@Olpy_Acaflo Have it working now.
For any other newbies the steps are:
Create a new fieldCustomise field-type to formulapaste in DATETIME_FORMAT({Date of Birth}, “MMDD”) = DATETIME_FORMAT(TODAY(), “MMDD”)Change {Date of Birth} to match your field.Cre...
@Olpy_Acaflo
what do you mean computed difference hits 0?
executive summary email will not do as you have to create a calendar base which is separate from my CRM base.
PSN
