The total number of days before a date is reached (code)

Knack 101 Tips & Tricks
1

Hi there.

I have a dates such as

18/12/2024

What I want to do is capture two different values in two other fields:

A) The number of days until that date is reached - changes dynamically (so that value will run down to 0 when 18/12/2024 is reached)

B) The number of days until that date is reached, at the time the record was added. So I can say that when that record was added to the system there were X days until the date was reached.

I saw that there was a getnetdays (from memory) or similar field that would not consider weekends. I’m therefore asking here for any help.

Thanks
GSH

2

Hi @GSH, you can use exactly what you mentioned: the netWorkDays() function in an Equation field.

Assuming you have Added date and Deadline date date fields:

image
image604×106 4.98 KB

You add a Days left from added equation field:

image
image467×254 11.2 KB

And a Days left from today equation field:

image
image461×245 11.3 KB

Both handle the case where the deadline date is earlier than either the added date or today’s date.

1 Like
3

Heroic, many thanks!

4

I don’t suppose you fancy doing a text field for those formulas?

5

You mean like this?:

Days left from added

{Added date} >= {Deadline date} ? 0 : networkDays({Added date}, {Deadline date})

Days left from today

currentDate() >= {Deadline date} ? 0 : networkDays(currentDate(), {Deadline date})
1 Like