Countdown from Original Date

[cgoodday]

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

[pbaldy]

Perhaps:

30 - DateDiff("d", DepositDate, Date())

[cgoodday]

Thanks for replying
This is what it supposed to be based on ur reply
CountDown: 30-DateDiff("d",[Date],[PaymentDate]())
However, when I try executing it, I receive the below error

And if I remove () from after paymentdate, it runs well but with the below value

I know its supposed to be about 28 instead of 0
Hope I make sense
Thanks

[pbaldy]

There's no error shown, but did you try what I suggested, exactly? You have it backwards I believe, and the parentheses need to be after "Date", though Access sometimes drops them. You can't have the brackets around Date, or it thinks it's a field rather than the function.

[cgoodday]

Yes, I did
I pasted the images but to my surprise, as u sent ur reply now. I observed the image did not send
However, I did another trick by creating Now() field and created another field called countdown and subtracted the payment date from the now field and it worked

[pbaldy]

I'm glad you have it working, though it sounds like an unnecessary workaround.

You can't just paste in an image on this forum, it must be attached:

https://www.accessforums.net/showthread.php?t=70301

[cgoodday]

Thank you very much

[Welshgasman]

This site gives the impression you can paste like other sites as it is visible after pasting, but is removed after submitting.

Wonder what genius though of that?

Imagine doing something similar in an access db, allowing a user to do something, show them the result, and remove it when they go to the next record.

[pbaldy]

I agree. Presumably the genius is employed by vBulletin and doesn't actually use the software.