Skip to main content

I am trying to create a view that is filtered for the last event/row that occurred > 90 days ago.


This is for my fleet maintenance tracker I use in AT.


Potentially, the structure I have created for this base may prevent me from accomplishing my task.


With that being said, I log maintenance in AT via entering a new row for EACH service. On each row, I post the date of service, type of service, and vehicle (along with some other nonessential data).


I am trying to create a simple view that displays vehicles whose LAST oil change is > 90 days.


Any thoughts?

Hi @David_Walters,


Filtering dates is tricky. Here’s what you’re looking for.



HTH, Nathalie

Hi @David_Walters,


Filtering dates is tricky. Here’s what you’re looking for.



HTH, Nathalie


Nathalie - thank you for your quick response!


Unfortunately, that is only half the solution and doesn’t fully address my challenge 😦 Please forgive me for my poor communication.


I am trying to create a view with formulas and filters that ONLY displays a record in the event (IF) it was the last record and it was > 90 days ago.


With the filter you provided, it shows ALL the previous events for an oil change > 90 days ago; regardless if there is an oil change < 90 days.


Again, maybe the structure which I have is limiting my options. Below is a screen shot of an oil change history view I use. Not sure if this helps!?


Nathalie - thank you for your quick response!


Unfortunately, that is only half the solution and doesn’t fully address my challenge 😦 Please forgive me for my poor communication.


I am trying to create a view with formulas and filters that ONLY displays a record in the event (IF) it was the last record and it was > 90 days ago.


With the filter you provided, it shows ALL the previous events for an oil change > 90 days ago; regardless if there is an oil change < 90 days.


Again, maybe the structure which I have is limiting my options. Below is a screen shot of an oil change history view I use. Not sure if this helps!?



@David_Walters - my bad! :face_with_hand_over_mouth: I missed the very large “LAST” 😆


Let me try that again. On your vehicle sheet, create a new ROLLUP column that rolls up the DATE field and for the function, select MAX (VALUES).




and to have it on your maintenance sheet, to create a LOOKUP column.


hth, Nathalie

Reply


Terms & Conditions