How to calculate remaining days between two dates (1 Viewer)

[Amena]

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?

 

[CJ_London]

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]

Hi Amena. Welcome to AWF! I would have thought “remaining days” would have been between the due date and today.