# Challenge with Last Date calculation using Lookup

**URL:** <https://community.glideapps.com/t/challenge-with-last-date-calculation-using-lookup/76355>\
**Category:** Ask for Help\
**Tags:** actions\
**Created:** [September 13, 2024, 3:32pm UTC](https://community.glideapps.com/t/challenge-with-last-date-calculation-using-lookup/76355 "2024-09-13T15:32:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Victor\_Bohbot](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/victor_bohbot/32/79661_2.png) [@Victor\_Bohbot](https://community.glideapps.com/u/Victor_Bohbot)\
**Post date:** [September 13, 2024, 3:32pm UTC](https://community.glideapps.com/t/challenge-with-last-date-calculation-using-lookup/76355/1 "2024-09-13T15:32:30Z")

</div>

Hi there,

I hope you’re well. I’m facing what I think is a challenging issue and am looking for assistance or brainstorming. I have a table with all the trainings, and each training has multiple dates. These dates can be updated in any order (e.g., I can create a training date today for the 15th of October 2024, and tomorrow for the 19th of September 2024). I want to determine when the last training date is forecasted.

I’ve tried retrieving all dates using a LOOKUP value and creating a new column named “Last Date,” but it only works when the latest added training date matches the actual last training date. I’ve attached a screenshot for better understanding of my issue.

I was thinking of using a FILTER with my LOOKUP but still haven’t found a solution. Perhaps there’s another approach I could take.

Thank you for your help.

Cheers,  
Victor

![Screenshot 2024-09-13 192420](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c75f000aa84b202e7e8520e2c960932c3b1634e.png)

 ![Screenshot 2024-09-13 193304](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0c6481ea94833c8b1e36542c8d34e24a75d4fca0.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 13, 2024, 3:44pm UTC](https://community.glideapps.com/t/challenge-with-last-date-calculation-using-lookup/76355/2 "2024-09-13T15:44:05Z")

</div>

Just use a Rollup Max instead of a Lookup and Single Value column.

---

<div class="post-metadata">

**Author:** ![Victor\_Bohbot](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/victor_bohbot/32/79661_2.png) [@Victor\_Bohbot](https://community.glideapps.com/u/Victor_Bohbot)\
**Post date:** [September 13, 2024, 4:18pm UTC](https://community.glideapps.com/t/challenge-with-last-date-calculation-using-lookup/76355/3 "2024-09-13T16:18:37Z")

</div>

It’s working, thank you so much! I was too insistent on using the LOOKUP value.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c50926a32800930b79052df32b9bc0f78e12e206.png)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 20, 2024, 4:19pm UTC](https://community.glideapps.com/t/challenge-with-last-date-calculation-using-lookup/76355/4 "2024-09-20T16:19:22Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.