Jed69 Posted February 4, 2008 Posted February 4, 2008 I am creating a button that performs a script to open a layout. I am using a perform find in the script to filter the records shown, but I want one of the criterial to calculate against the current system date but I can not fine what to use so that it references the current date. eg I want to have EndDate > CurrentDate Where end date is the relevant field.
Inky Phil Posted February 4, 2008 Posted February 4, 2008 Have a look at Get(CurrentDate). That returns the current date as set by the system HTH Phil
Jed69 Posted February 4, 2008 Author Posted February 4, 2008 Yea I though that, as I have used it in Calculations before but in this format it didn't work it just told me it needed a valid date format.
comment Posted February 4, 2008 Posted February 4, 2008 Try: Go to Layout [ Your Layout ] Enter Find Mode [ ] Set Field [ YourTable::EndDate ; ">" & Get ( CurrentDate ) ] Perform Find [ ]
Jed69 Posted February 4, 2008 Author Posted February 4, 2008 Sorry guys just found it. I have been really stupid. Aparently // in this find means today's date
Recommended Posts
This topic is 6138 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now