Hi,
I've been trying to find the answer as I'm sure it's already here. Can I please have support on the following; either a link or direct information.
I am creating a db and within it the user would add a 'created date', and later in a separate field a 'closed date'.
What I am trying to track is the number of days between these days (which I can do), plus in addition.. IF the 'closed date' has not been completed i.e. issue is still open, then the calculation is from the 'created date' until TODAY's date (date()), and continues to run until a date is actually inputted.
This is pickling my small brain!
Your help is greatly appreciated.
Thanks in advance
I've been trying to find the answer as I'm sure it's already here. Can I please have support on the following; either a link or direct information.
I am creating a db and within it the user would add a 'created date', and later in a separate field a 'closed date'.
What I am trying to track is the number of days between these days (which I can do), plus in addition.. IF the 'closed date' has not been completed i.e. issue is still open, then the calculation is from the 'created date' until TODAY's date (date()), and continues to run until a date is actually inputted.
This is pickling my small brain!
Your help is greatly appreciated.
Thanks in advance