Hey Guys, I am reaching out to all the Airtable Ninjas out there for some formula help. The end outcome that I am looking at achieving is ‘Month-Year - Week of month’. e.g. ‘Nov-2018 - W1’.
Here is my formula.
DATETIME_FORMAT({SCHEDULED DATE},‘MMM’) & “-” & DATETIME_FORMAT({SCHEDULED DATE},‘YYYY’) & " - W" & VALUE(DATETIME_FORMAT({SCHEDULED DATE},‘w’))- VALUE(DATETIME_FORMAT(DATETIME_PARSE(‘01’&DATETIME_FORMAT({SCHEDULED DATE},‘MM’)&YEAR({SCHEDULED DATE}),‘DDMMYYYY’),‘w’))+1
It throws a ‘NaN’ error message.
