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

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.

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?

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

Try:

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

Thanks, Ender!

Thanks Ender - your solution was spot on!

Frank