A Amena New member Local time Yesterday, 21:59 Joined Sep 11, 2019 Messages 1 Sep 11, 2019 #1 Hello, I am creating a task management template in access. I would like to calculate remaining days left to finish the task between task [Assigned Date] and [Due Date] in query. How do I solve this issue?
Hello, I am creating a task management template in access. I would like to calculate remaining days left to finish the task between task [Assigned Date] and [Due Date] in query. How do I solve this issue?
C CJ_London Super Moderator Staff member Local time Today, 05:59 Joined Feb 19, 2013 Messages 17,396 Sep 11, 2019 #2 use the datediff function datediff("d", [Due Date],[Assigned Date]) you may need to swap the two fields around depending on whether you want a positive or negative value
use the datediff function datediff("d", [Due Date],[Assigned Date]) you may need to swap the two fields around depending on whether you want a positive or negative value
theDBguy I’m here to help Staff member Local time Yesterday, 21:59 Joined Oct 29, 2018 Messages 22,496 Sep 11, 2019 #3 Hi Amena. Welcome to AWF! I would have thought “remaining days” would have been between the due date and today.
Hi Amena. Welcome to AWF! I would have thought “remaining days” would have been between the due date and today.
