Search results

Well there will always be an Approved Date but the Check Date is input at a later time. So I need it to work once the Check Date is input. Does that make sense?

I have the box set as unbound and I have my formula in the default value. I don't know the other ways to do it.

Wait..... :( It calculates the correct number of days for my first record and then that same # of days is on all other records. What did I do wrong?

I got it! Thank you for saving my sanity! :)

So I can set up a field in my form? That is what I really need. I have people who are going to be entering stuff in a form and I need them to know if it is over 30 days between 2 of the fields. I will try that if I can. Thanks!

Hi All, I am still learning and need help!! Can I use the DateDiff function in a table? I have the formula: DateDiff("d",[Approved Date],[Check Date]) but when I try this I get a message that it doesn't recognize Approved Date?? What am I doing wrong?? :eek: