
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 10, 2020 07:45 AM
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! :slightly_smiling_face:
Gareth
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 10, 2020 08:26 AM
@Gareth_Procter, If I understand what you’re trying to do, this formula should work.
DATETIME_DIFF(DATEADD(Date,{Service days},'days'),TODAY(),'days')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 10, 2020 08:48 AM
Thanks Nathalie - somehow you managed to understand the terrible description of my problem and give me an answer that works!!!
