I need to know if this is possible. I have a table that lists projects, with two different “priorities”, so to speak. One we need to meet on every 7 days, one we need to meet only once per month. I can add in our most recent meeting date, and then calculate a date from that. It’s simple…until I need to calculate the next meeting due date based upon priority. This probably doesn’t make sense, sorry.
I tried nesting the dateadd within an if then statement, but I kept getting an error.
Writing it out, this is what I need:
If priority = A, then due date is most recent meeting plus 7 days
Else due date is most recent meeting plus 30 days
Right now, I just have the two project types in different tables to keep the calculations simple, but I’d like them all in one table. Ideas??