I want to write a formula, I have a field created, which is a date field, however, I want to make this field a condition field in view, whereby the formula for the column in the field will no longer be dynamic if current date exceed 31 March of following year (where year refers to the field in the document as mentioned earlier), I was thinking of @Adjust, but this only change the date.
Subject: How to write formula for condition up to 31 March following year?
Give an example. A scenario and the results you are looking for. Is this just for the view’s sake or for the document’s sake?
It is not clear from your post what exactly you are wanting to do.
Subject: RE: How to write formula for condition up to 31 March following year?
Tq for Smith, I just found this formula @Date, maybe it will solve my problem. I created a column, it will capture the value of the field November in the document, if status of document is forecast and the year is current year. (I have another field which will register the value of document being created, this will be used by the column in determining the year is same as current year). However, it should not be capturing this value, should the current period exceed 31 March next year, as the forecast value is superceed by actual value.