If what you want to do is make the selection simpler for the user, by means of a button, for example, create a button, go to its properties, Actions tab, add a new action type Selection, Select in Field, set update_date as field and
As the search string. Make sure using a text object that this function returns in the same format that your update_date field is. You can also set this action to be triggered when the document opens (Settings menu, Triggers tab, On Open event) or when a sheet is activated (right click on any empty space of the current sheet, Properties).
If you need to load only those records where update_date equals to that date, you can do that using a variable:
LET vDate = Date(Today() -91); Data: LOAD *; SQL SELECT * FROM Table WHERE update_date >= '$(vDate)';
Provided as above that the update_date and the result of '$(vDate)' are in the same format.
Hope that helps.
Thanks a lot for the example of the correct syntax, that's one of the things that trips me up learning this language. The button-search-string method doesn't work, though.
The update_date field has the default date format (M/D/YYYY h:mm:ss TT) and I haven't changed the search string you provided either. Should I override the document settings for the date format in the update_date field?