Skip to main content

Hi all,


I’d appreciate help on this if at all possible?


I am trying to write a formula which counts down from a date field called ‘Last Service’ by a number of days as stipulated by a field called ‘Service Days’. Service Days is an integer which describes the number of days between each service activity. i.e. ‘14’ would indicate that there is a service every 14 days.


So if the ‘Last service’ was on 01/01/2020 (DD/MM/YY), and the ‘Service Days’ was 14, on 10/01/2020 the new formula would calculate ‘4’ (4 days left until next service).


I hope that makes sense and sorry if it is something that has been answered before - I tried to look but couldn’t find the answer! 🙂


Gareth

@Gareth_Procter, If I understand what you’re trying to do, this formula should work.


DATETIME_DIFF(DATEADD(Date,{Service days},'days'),TODAY(),'days')

@Gareth_Procter, If I understand what you’re trying to do, this formula should work.


DATETIME_DIFF(DATEADD(Date,{Service days},'days'),TODAY(),'days')



Thanks Nathalie - somehow you managed to understand the terrible description of my problem and give me an answer that works!!!

Reply


Terms & Conditions