I have two date fields and would like to pull out the months and years in separate fields from one or the other.
I managed to get the single IF working but not the nested function. Here’s my formula:
IF({Date A}, DATETIME_FORMAT({Date A},’YYYY’), IF({Date B}, DATETIME_FORMAT({Date B},’YYYY’)))
which I based on:
IF([logical argument1], [value1], IF([logical argument2], [value2], [value3]))
Any help would be appreciated.