Lookup Nearest Date in one list to update second list

(0) Share

Report

Posted on by frome2000

I have a list of "clients" and a list of "tasks". When a new task is added I need to check through the tasks list for that client id and if the new task due date added is closer than the existing "soonest date" field in the client list, update "soonest date" to the newest date.

I understand how to update between the lists but I am not sure how to get it to compare the dates.

Thanks

All responses (1)

Answers (0)

Michael E. Gernaey 43,220 Super User 2025 Season 1 on at

Like (0)

Report
Re: Lookup Nearest Date in one list to update second list

Hello,

Is this a planner task list, or a SharePoint task list?

If you have the list when you query your list

If(newdate < First(SortByColumns(Filter(mylist, clientid = 12345), datefield, descending)), it is less so swap or whatever , it is not so add it ); //give that a shot. since I dont know the lists I'm guessing here a little at your needed format
Cheers
--------------------------------------------------------------------------------
If I had answered your question, please mark your post as Solved
If you like my post please give it a thumbs up
Thanks
Michael Gernaey MCT | MCSE | Expert | Ex-Microsoft
https://gernaeysoftware.com