...

1. Click the Find button in the toolbar.

2. Click the Advanced tab.

3. Click the Query Builder button in the toolbar. 

   Div
   Image Modified

   
   

4. Enter your query.

5. Click OK.

6. Click Exec button in the toolbar or the Exec button on the right in the Find window. 

   Div
   Image Modified

   
   

Advanced Functions

Advanced functions allow you to filter results and/or get user input to add to you find.

...

SELECT dbo.localizedate (DateTime, 'Zip code');

Change DateTime to the datetime needing to be localized, and ZipCode to the zip code to use to determine the timezone for localizing the datetime value. Using the statement above will result in a YY-MM-DD hh:mm:ss.s. For example, the date output would be 2020-09-04 17:17:20.887.

...

Place the following in the query as its own line will cause the query to ignore any max records restrictions. Grids have a limitation of 250,000 rows, and any dataset that exceeds this will not be visible.*

...