Create a calculated control, calculating the number of days from the last date

%3CLINGO-SUB%20id%3D%22lingo-sub-3364124%22%20slang%3D%22en-US%22%3ECreate%20a%20calculated%20control%2C%20calculating%20the%20number%20of%20days%20from%20the%20last%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3364124%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20collections%20list%20which%20has%20three%20columns%20for%20notices.%20So%20a%20client%2C%20who%20hasn't%20paid%20a%20bill%2C%20will%20be%20notified%20three%20times%20before%20their%20account%20will%20be%20turned%20over%20to%20collections.%20I%20would%20like%20to%20create%20a%20calculated%20control%20that%20would%20determine%20the%20number%20of%20days%20that%20have%20passed%20from%20their%20most%20current%20notice.%20For%20example%2C%20Client%20A%20was%20first%20noticed%20on%2002%2F01%2F2022%20and%20then%20noticed%20the%20second%20time%20on%2004%2F02%2F2022.%20Client%20B%20was%20first%20noticed%20on%2003%2F30%2F2022.%20Client%20C%20was%20noticed%20first%20on%2004%2F03%2F2022.%20I%20would%20like%20a%20calculated%20control%20that%20would%20determine%20the%20number%20of%20days%20from%20the%20LAST%20notification%20for%20each%20client.%20So%20client%20A%20it%20would%20be%20looking%20at%20the%20second%20notice%20date%20to%20today%3B%20client%20B%20would%20be%20looking%20at%20the%20first%20notice%20date%20to%20today%20and%20same%20for%20client%20C.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20tips%20on%20how%20to%20create%20that%20calculated%20control%3F%20The%20%23%20of%20days%20would%20always%20be%20determined%20from%20the%20last%20notice%20to%20today.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3364124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I have a collections list which has three columns for notices. So a client, who hasn't paid a bill, will be notified three times before their account will be turned over to collections. I would like to create a calculated control that would determine the number of days that have passed from their most current notice. For example, Client A was first noticed on 02/01/2022 and then noticed the second time on 04/02/2022. Client B was first noticed on 03/30/2022. Client C was noticed first on 04/03/2022. I would like a calculated control that would determine the number of days from the LAST notification for each client. So client A it would be looking at the second notice date to today; client B would be looking at the first notice date to today and same for client C. 

Any tips on how to create that calculated control? The # of days would always be determined from the last notice to today.

0 Replies