How can I use our “Expected ship date” in transaction mode to mark or identify how many overdue lines we have? “if estimated ship date > 15 days ago then mark/show as overdue”. I can use a static date in Advanced Search but is there something dynamic?
I can’t think how to do it in transaction mode but you could add a column in the database design to calculate Days Overdue based on the current date vs Expected Ship date using when the database is built and use that as your filter and it would be dynamic?
1 Like