On 2008 Jun 14, at 11:51, cdyer wrote:
FMA 8.0.3, Xplatform
I'm better than this, but I cannot find the problem with my
scripted find.
User inputs either or both a "from" date and "to" date of a date
range in custom dialog. Values are then used to insert the find
criteria into a date field.
Insert Calculated Result [ ToDoList::AssignedDate;
Case (IsEmpty ( ToDoList::DateRange_From ); "";
ToDoList::DateRange_From)
& "..." &
Case (IsEmpty ( ToDoList::DateRange_To ); "";
ToDoList::DateRange_To)
]
I can verify the criteria are getting set.
When the find is performed, no records are found, but there are
records within the date range entered. (I've tried
1/1/2000...6/14/2008 which should get everything) No other
criteria is getting entered.
If in browse mode, I immediately Modify Last Find, again, no
records are found. If I copy the date range from the Modify Last
Find and perform a manual find pasting the date range, it works.
Any ideas why the scripted find doesn't work?
Chuck
3 guesses:
(1) The "Date" field you're pasting into isn't defined as being of
"date" type. (Unlikely but worth checking)
(2) You're entering the start date and stop date while you're in
Browse mode but not committing the record before entering Find mode.
(3) You're entering the start date and stop date while you're
already in Find mode.
