Thank you for your responses. The problem i am having is that ( Currentdate + 1) gives me the answer but the answer remains stagnant - i need the answer to change every day.
I created a field called CURRENTDATE1 which = (CurrentDate)+1. The field is formatted to look like a date (12/20/2006) When i try to create the script to automatically give me tomorrows date by entering a find with the formula INSTDATE = (CurrentDate1) I receive an error message "The value of this field must be a valid date in the range of years 1 to 4000 and should look like "12/25/2003" I am at a total loss.
You don't need to make a formula. You would just use
{table.INSTDATE} = currentdate + 1
... in report->selection formula->record. I would check two things. Go to Report->Set Print Date and Time and make sure that "Today's Date and Time" is checked. Also place the INSTDATE field in the detail section and verify that it is in fact a date or datetime field by running the mouse over it and observing the tool tip text, and also check the year displayed in INSTDATE.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.