I searched the forums and I couldn't find my answer.
Here is situation: For example:
We receive an appeal 10/1/06, the State mandates that we complete the Appeal in 45 calendar days. We send the Appeal to claims for handling and sometimes they don't reply back in time and we get fined. So, I want a due date on the form to show the date a reply is needed to the State.
I have a received date field
I have a sent to claims date field
I have a due date field
I have a State field
I have a follow-up days State field
Can you have a date add function that adds the number of follow-up days depending on the State, there are several different date rules, some States are 20 calendar and some are 30 calendar days.
I might be better off just running queries that lists the claims that are close to the due date.
And I might be totally off here, so if you have any suggestions or questions, let me know.
Thanks!
Here is situation: For example:
We receive an appeal 10/1/06, the State mandates that we complete the Appeal in 45 calendar days. We send the Appeal to claims for handling and sometimes they don't reply back in time and we get fined. So, I want a due date on the form to show the date a reply is needed to the State.
I have a received date field
I have a sent to claims date field
I have a due date field
I have a State field
I have a follow-up days State field
Can you have a date add function that adds the number of follow-up days depending on the State, there are several different date rules, some States are 20 calendar and some are 30 calendar days.
I might be better off just running queries that lists the claims that are close to the due date.
And I might be totally off here, so if you have any suggestions or questions, let me know.
Thanks!