Skip to main content


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], gvalue1], IF(llogical argument2], gvalue2], [value3]))



Any help would be appreciated.

I copied your formula exactly and it works for me. Is it possible that the {Date A} field in row 2 isn’t truly blank? Perhaps there’s an empty space in it?


The reason for that is the use of curly apostrophes (’) instead of straight ones (')

Reply


Terms & Conditions