Date Range Script

[Bioboy]

I am trying to write a script that finds a range of records between StartDate and EndDate fields. I have a Date Created field which is what I wound the search to be done on.

I tried using this:

Enter Find Mode []

Set Field ["Date Created", "StartDate"]

Paste Literal ["Date Created","..."]

Paste Result ["Date",EndDate"]

Perform Find []

Like the June 5 post from ZuperZZ suggested, but I quickly found out that my version of FM does not have the Paste Literal command in Scriptmaker. Am I missing something (i.e. I'm stoopid) or is it really not there..

Or is there another way to achieve this?

Thanks to all who reply.

[LiveOak]

In their infinite wisdom, FMI has decided to change the names of script steps to alternate names which are not more descriptive than the original names for some totally unknown reason.

Instead of Paste Literal try to Insert Text script step. Make sure the script selects a layout on which the field appears before executing this script step. "Paste" and "Insert" won't work unless the field appears on the current layout. -bd

[Bioboy]

liveOak,

I can see how this will work, but when I plug it into my script, the script , the Insert Text command pastes the "..." over the whole field, eliminating the StartDate value. I double checked that the "select" option is OFF, but it makes no difference. Is there a cursor command that I need to use to ADD the inserted text into the field after the StartDate value has been set to the field? I then need to add the EndDate field value into the DateCreated field AFTER the range command. I just don't know how to get around this.

Thanks for your response LiveOak.

[Vaughan]

Try using the Insert Calculated Result script step instead, and generate the whole search string in one hit.

Start Date & "..." & End Date

This way you don't have to muck around with the "date Created" and "Date" fields like you did in the example you gave. Just pop the fields directly into the calculation and go.

[Razumovsky]

Hi All,

I am streamlining an old database I made to get rid of copy and paste steps, but am stumped on daterange step for finds. Came up with a few old posts addressing the question (like this one), but it doesnt seem to work for me.

insert calculated result[select "d_date", "g_datefind1&"..."&g_datefind2"]

does not do the trick, neither does any combination of text to date functions that I have tried with the above fields/data.

d_date is a date field

g_datefinds are date fields

Have things changed, is the above posts in the thread incorrect, or is it too early in the a.m. for me?

-Raz

-Edited-

Oh, I suppose it is too early...

DateToText(g_datefind1) & "..." &DateToText(g_datefind2)does the trick. Not really sure why though.

[jasonwood]

DateToText(g_datefind1) & "..." &DateToText(g_datefind2)does the trick. Not really sure why though.

Because the "insert" script steps are similar to typing the date manually, the date field wants the date formatted a certain way (as if we were typing it).

DateToText() converts the date from the way it is stored to the way we (and the field) understand it.

[RussBaker]

The Set Field script step requires the data that is being set to be of the same format as the destination field - so it rejects things like "..." and "<" as being non-date characters. Insert Calculated Result is the way to go. If you download my Handy Bits file in the Samples section of this forum (it will be on page 2 or 3 by now - and pick the last one on the list) you will see lots of examples under the date tab of how to script finds for date ranges.