I have a table with a list of contracts that has fields for CompanyName (link record to a company table that lists all the companies) and ContractStartDate.How do I filter or find the oldest record for each Company based on ContractStartDate? A compa...
I'm struggling to figure out a good way to determine if a projects start and end date span any part of a specific year where start and end dates could span multiple years.So for example, I have records with the following columns for projects:Project ...
I have a table that contains subscription dates using the date field. I’m trying to create a new grid view with a filter that just shows dates that fall into the current month. Seems simple, but I can’t figure it out. I can see how I can use the “is ...
Thanks.I had tried that, but what I end up with is the date of the oldest contract, but no way to correlate that to the linked contract. Maybe I'm missing something with the filters?
Thanks for the tip. I had seen something along those lines in a post from a few years back and was hoping there was some sort of update. That said, this will work for now.
Thanks
