-
Active Record Count as of Certain Date
I'm trying to figure out the best approach for a Beastmode or other suggestion, to count the number of Active Records in a data set for a given period of time. Each Record has a Started Date and may …1 -
Determining if a record falls on the first day of a quarter and if not collect it in the next Quarte
I have been presented with an interesting task, I have a dataset that contains all of our sales records and our company measures SSS (Same Store Sales) Year over year. I solved this fairly easily by …1 -
Re: Active Record Count as of Certain Date
Further Information possible progress I've modified my Beast Mode and I can now flag a record as being Active, Term Today or Future Term. If I use CurrentDate() as the date requirement everything is …1
