Finding Records on Timestamp Field

[Jessica_BLUE]

Hi everyone. Currently i got BeginDate as timestamp, i want to create a report searching based on BeginDate, but because it's timestamp, brings me all, i guess i got to use a wildcard, but im not sure how.

i have:

enter find mode

set field [Cajas::BeginDate;GetAsText(tempvars::BeginDate)

&"..."&GetAsText(tempvars::EndDate)]

perform find.

how should i use the wildcard? do i have to convert the timestamp to a date, and then search?

thanks

[FM_SouthAfrica]

You probably first need to break up your timestamp into date and time fields/data seperately . . . try create another calculation field using : LeftWords ( Timestamp ; 1 ). This should give you back just the date, then your idea of entering find and setting this new field with the START and '. . .' and END should work.

[mr_vodka]

Are tempvars::BeginDate and tempvars::EndDate global fields? If not then set them to globals, or capture the data into variable prior to entering find mode.

[Jessica_BLUE]

ok, i break up, my timestamp into date, and apparently, it's correct but when i do the find, still brings me all....

also the tempvars::begindate and enddate are globals.

[LaRetta]

I believe it breaks because it is specified as GetAsText(). FM can't find a date or timestamp that way. If you have two global date fields, you can simply enter the dates so:

Enter Find Mode [ ]

Set Field [ BeginDate ; gBeginDate & ".." & gEndDate

Perform Find [ ]

FileMaker will insert the *:*:* for the time automatically.

[comment]

The GetAsText() is unnecessary, but it should work with it too. At least it does so with 8.5, so the problem is likely to be something else. Which version introduced wildcards?

[comment]

Can you put a pause just before Perform Find [ ], and report what you get as the find criteria?

[LaRetta]

Wildcards were introduced in vs. 8 and I tested using vs. 8. But if the operating systems changed then GetAsText() won't necessarily work. I thought it was unreliable even with time settings. Sorry if I might have mislead here!

Hey John! Maybe it's the moon!

[comment]

Oh, I think the GetAstext() should definitely be removed. I'm just not convinced it is the cause of the current problem. But we should know soon.

[Jessica_BLUE]

i put a show custom dialog, and it's breaking correctly the BeginDate(timestamp) but, for some reason doesn't find me what i want

[mr_vodka]

It should work as expected if those fields are global. Try reindexing your tiemstamp field.

[Jessica_BLUE]

it works! thanks for your help