Countdown Date
Hi,
I have a problem with a formula
I would like to calculate how many months from today to a certain date
this as written but it does not give me any results.
let Countdown := round((today()  Fine) / 2592000000 * 1);
tnks
10 replies

Hi,
Can you try the following:
floor(number(today()  Fine) / 2629746000)

You can also try:
let x := if year(Date) > year(today()) then 12 + month(Date) else month(Date) end; month(today())  x
It is not as short but a bit more understandable to those new to Ninox date fields.

Hi, you made me rethink this.
It is a matter of problem definition. Let's say that 'Date' is yesterday (31/07/2024 or 07/31/2024):
If we are interested in counting the changes in the calendar months between today and yesterday then the answer is (1) month based on your solution.
On the other hand, if we are interested in counting the duration of time in months then the answer is (0) month based on my solution (to be precise is one day).
which of the problems mentioned above are you trying to solve?
Content aside
 Status Answered
 1 mth agoLast active
 10Replies
 83Views

4
Following