Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Future Date


page19
 Share

Recommended Posts

Hi, I'm working on a FM database for a friend and I've reached a point where I'm stumped as how to do it so was just wondering if some kind person can help me please.

What I would like to do is have the database, upon opening, automatically find records based on a date field that is 30 days in the future. For example, if the current date is 01/01/2020 then I would like to create a script that automatically finds all records that have the date 31/01/2020 in a certain field and have a simplified report card (with just 2 or 3 details from the main database) show up displaying which records they are.

Any help will be much appreciated.

Thanks.

Link to comment
Share on other sites

Set a variable, put that into the find.

Set Error Capture [On]
Set Variable [$date; Value: ">" & get(currentdate)+30]
Enter Find Mode [Pause Off]
Set Field [YourTable::YourDateField; $date]
Perform Find [ ]

Don't forget to trap for errors.

Link to comment
Share on other sites

Your using set field incorrectly.  There are 2 dialogs.  The first one 'Specify Target Field' you select the field, presumably 'Contacts::Accounts Date'.  The second one 'Calculated Result' you just put in the variable by itself $date

image.png.2b529d34220023d4f0337f93f8d2f1fd.png second one

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use