I'm having an issue with trying to retrieve records with one of the retrieve criteria being in a date field.

var vCombo as String
VCombo = Start_Date0 + ".." + End_Date0
(Entered is a Date element)
(Temp is Text element)

(Start_Date0 is a Text element populated with popup calendar)
(End_Date0 is a Text element populated with ppup calendar)
Start date selected is 2006/06/01
End date selected is 2006/07/31

Report launched by command button.
Programming, in part:
Temp = vCombo
Entered = vCombo

WriteLn returns results as:
Temp = 2006/06/01..2006/07/31
Entered = 0000/00/00

If I try @Str(Temp) or @Str(vCombo) the result is 2006/06/01 -- only the Start_Date appears.

I've tried playing with FormFieldValue and @FormFieldValue with no luck.

I guess the question is, how do I get the Entered element to accept a String with the date range 2006/06/01..2006/07/31 like the Temp element accepts?

Thanks in advance for your support!
Fred

Hi Erika,

This is one of the attempts with FormFieldValue:

FormFieldValue(@Layout, "Entered", 0, Start_Date0 + ".." + End_Date0)

That returns 0000/00/00

Another was:

FormFieldValue(@Layout, "Entered", Start_Date0,0 + ".." + End_Date0)

That returns 2000/08/15 (SIC)

Search (blue)

No - it's an on element entry for a command button.

Sequence is:
Combo box for Equipment - captured to variable
Select Start_Date from popup calendar (down arrow element pops up calendar and fills element "Select_Start_Date)
Select End_Date (ditto above)

Select command button which fills a field "Status" with UNP;
inputs the Equipment variable that was saved to an element named Equip
SUPPOSED TO take info from Start_Date, add two periods, and add data from End_Date to element Entered. Then uses SelectTreeItem to retrieve records.

But I'll go play with the Retrieve Spec Open event!

The real question is - if I can can a text element named Temp to produce the desired results, 2006/06/01..2006/07/31, why wouldn't a simple statement like Entered=Temp work? Temp is a text field, and Entered is a date field, but being in the Search(blue)mode, the date field should accept a string from a text field, shouldn't it?

Also, since WriteLn shows the string 2006/06/01..2006/07/31 for Temp element I tried the following:
FormFieldValue(@Layout, "Entered", 1, Temp)
This returned: 2006/06/01 in WriteLn for Entered

TOTALLY confused - and about to start a second glass of wine!! (That always helps the creative mind, doesn't it??)

Also, is it possible to change an element from a bound to "Date" to a bound to "Text"? That'd probably solve this issue.

Am willing to send .dsr and .ddt files for evaluation. Was that to Support@lantica.com?