I am trying to display a real time count down of days left from a defined date on a form.
I have a field "DispatchDue" calculated from a field"GoodIn" which is normally todays date. I would like a count down of days remaining until "DispatchDue". I have tried various options using datediff and Now() functions but cant get it to do what I require.Is it possible to have a count down of days left in real time and either add this to my table or display it on my form?
so say theres a date in my field DispatchDue 28/03/2017 I would like it to display : "6 days Remaining"
so it looks at todays date and then minus from dispatchdue but I want it to automatically do it each day.