Hi guys.
I have a query with date of deposit and date of payment
Between date of deposit and payment is 30 days
i.e my clients pay for for their trade and I am expected to pay them back their capital and profit in 30days time
So, date of them paying in is called "DepositDate" and date of paying them back with their accrued interest is called "PaymentDate"
Between these two dates, I have a duration of 30 days
I need to create a field in the query to be counting down from the 30 days to 0 days as a daily reminder.
Thanks.
I hope I make sense