General information
Category:
Coding, syntax & commands
Title:
Finding the right records
I have a table that lists documents that are due to our vendor. Each record has a Due Date and a Submitted Date field. My goal is to find out how many documents are late each month. My first attempt is to find all records that have a due date <= to date() And a submitted date >= date() - 30 days And submitted date > due date. This only gets some of the records. It misses the records that don't have a submitted date at all yet. How can these two criteria be combined together?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only