I have ReminderDate and ExpiredDate in my table. I want that reminder form pops up when the reminderDate is less than 30 days before expired date. How can I write this in code. I watched you DateTime seminar and Barcode seminar. I wrote this code but it didn't work. X = Nz(DCount("*", "ProductUnitQ", "Closed=FALSE AND ReminderDate<#" & ExpiredDate - 30 & "#"), 0). Thanks!
Masih
Masih Ostad Novin 13 months ago
I guess my code was a mess, X = Nz(DCount("*", "ProductUnitQ", "Closed=FALSE AND ReminderDate<#" & ExpiredDate-2 & "#"), 0)
What I want here is to specify the date: Reminder date should be 2 days before expired date. Can you please help me with that?
