Hello
I have a strange issue that I am hoping someone can help me with.
I have a date field where I am trying to create a separate field to determine in which fiscal/financial year the date falls.
I have done this in the past and it has worked perfectly.
But now when I come to use exactly the same formula, and trying to ensure the field formats are the same then I am returned a 1905 date - I know that this is sometimes an issue in excel regarding the date as a number but I cant understand why my formula that has worked before now doesn't.
Any help would be gratefully received.
I have a strange issue that I am hoping someone can help me with.
I have a date field where I am trying to create a separate field to determine in which fiscal/financial year the date falls.
I have done this in the past and it has worked perfectly.
But now when I come to use exactly the same formula, and trying to ensure the field formats are the same then I am returned a 1905 date - I know that this is sometimes an issue in excel regarding the date as a number but I cant understand why my formula that has worked before now doesn't.
Any help would be gratefully received.
