RyanParr
9 years agoQrew Assistant Captain
Is there a way to extract data from a log entry based off of a date range search?
Our application contains a Companies table. Each Company has a Status field (Current Client, Former Client, Potential Client) which will log entries. Companies can be set to current, former etc. on any day of the month which has become an issue.
At the end of each month we would like to pull a report that shows any Company who?s Status value was ever equal to Current during a particular month. i.e. a list of all Companies that ever had a Status Value equaling Current during January 2017.