Return Data between 2 dates

[aguest]

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

[eos]

Try

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

[Kris M]

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 [ ]

[LaRetta]

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.  :-)

[LaRetta]

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

[eos]

eos missed one period to form the ellipses

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

[Kris M]

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

Once again schooled by eos.

 

Edited June 24, 2015 by Kris M

[eos]

Once again schooled …

You're too kind (or facetious …  )

[aguest]

thank you that has worked a treat.