I have a business requirement to validate the data entered by user & write an error message if the data is not valid. for example, if the user tries to modify the existing data, we need to check if the date specified by the user is in the current quarter or not. If it falls in the current quarter (we are storing the dates in a table, so that we can refer to that table while validating) we need to save the data else need to throw an error message.
Is there a way to do this in character relation ships using derive or do we need to use Fox formula in a planning function. Appreciate your help.
I am new to IP and could not find any how to documents or similar topics. Please suggest.
Thanks in Advance