Hi,

 

I know this is a very simple request that can be carried out with an enter find mode but I can't seem to get it to work for me.

I've got a table with a number of records and I only want to show records that are between 2 certain date through the use of a script.

TIA

Try

Enter Find Mode [ no restore ]
Set Field [ Table::dateField ; date1 & ".." & date2 ]
Set Error Capture [ on ]
Perform Find [ ]

eos missed one period to form the ellipses

Enter Find Mode [ no restore ]
Set Field [ Table::dateField ; date1 & "..." & date2 ]
Set Error Capture [ on ]
Perform Find [ ]

This is rightfully assuming you are searching a single date field and you have not mistakenly used two different fields in same record, one for start date and one for end date.

... but I can't seem to get it to work for me.

Usually telling us something 'didn't work' is not as helpful as providing the script you used.  :-)

Actually, Kris, two works perfectly well unless you are searching decimal numbers.  :-)

eos missed one period to form the ellipses

No, I didn't. Two periods work just as well as an ellipsis.

No, I didn't. Two periods work just as well as an ellipsis.

Once again schooled by eos.

 

Edited June 24, 201510 yr by Kris M

Once again schooled …

You're too kind (or facetious …  )

thank you that has worked a treat.