Due Today, Tomorrow & Next Week calculations
I'v been trying so hard NOT to have to post a question for the last three weeks. But, for the life of me, I can't figure this one out.
In a Table called "Manufacturing Orders" I have a Field named "Order Due Date." (It's a drop-down calendar field.)
Then, assigned to a pop-up menu button, I have a Values List that contains: Due Today, Due Tomorrow, Due Next week, Order Due Date, Order Entry Date & PO#.
When the a value is selected, an "OnObjectModify" script is triggered to sort the order of the records that contain that data. I'v been able to write the scrips needed to sort and display basic field data, but I'm having the hardest time trying to write a script that will return a calculation that shows me records where "Order Due Date" is = to Today. Or, where "Order Due Date" is = to Today + 1 day. Or, lastly, where "Order Due Date" is = to Today + 7 days.
The calculation should return a calendar date.
Any help or tips would be greatly appreciated.