Searching a date range via scripting

[fbugeja]

To simplify enttry of dates into a Date field on a search screen, I am toying with the idea of buttons on a layout which have "Today","Yesterday", "Last 7 Days", Last 14 days", etc which, when clicked, go to another layout (a search layout) and set the date in the Date field. I am using the SetField Command, so to show dates from the last 7 days I have:

SetField[File:Date;">"&Get(CurrentDate)-7]

Problem: Can the SetField command be made to show a date range e.g. 1.1.2005...3.1.2005?

Frank

[aaa]

Instead "Set field" comand in that case you must put "Insert calc result" comand.

But you must have date field in the layout where you want to search your range.

[Ender]

aaa, in FM7, you can use Set Field[] instead of Insert Calculated Result[] to insert a range for a find.

Frank, I'm not sure what you're asking. Yes, you can use Set Field to insert a range in that format. Did you have trouble with that?

[fbugeja]

Ender

For single dates (e.g. today, yesterday) and SetField example that I included in my first post worked. I think the problem lies in the way that I write the range. I need to do some experimentation e.g "1.1.2005"&"2.3.2005". Will keep you posted on my experimentation!

Frank

[Ender]

Try:

Set Field [ File::Date ; Date(1;1;2005) & "..." & Date(2;3;2005) ]

[aaa]

Thanks, Ender!

[fbugeja]

Thanks Ender - your solution was spot on!

Frank