Date Range

[ngowran]

I want to create a script which simply does a search and displays records which are set to today and beyond, i have a "deadlinedate" date field set.

I have tried a couple of ways but can't get any success, any suggestions are appreciated.

[mr_vodka]

Since you are on FM6...

IIRC, it should be like the following:

Enter Find Mode

Insert Calculated Result [ YourField, ">=" & (Status(CurrentDate)]

Perform Find

Or if you want specific ranges:

Enter Find Mode

Insert Calculated Result [ YourField, DateToText(DateStart) & "..." & DateToText(DateEnd)]

Perform Find

P.S. Go to the layout with the field on there first.

Also, if you are not on FM6, then please update your profile first... second you can use Set Field instead of Insert Calculated Result.

[ngowran]

Hi, I try to use Insert Calulated result:

DateReqd, ">=" & (Status(CurrentDate)

but it says "There are too many separators in this function.

If i take out the comma, i get another error saying the field cannot be found and it highlights the first double quote as being part of the field.

[LaRetta]

">=" & [color:red](Status(CurrentDate)

Remove the red parenth as indicated so it becomes ">=" & Status(CurrentDate)

Yikes! and remove this DateReqd, entirely!! This is where you specify the field to set (the target field) and that field does NOT also go into the calculation dialog.

Edited April 15, 2009 by Guest
Added yikes!

[Lee Smith]

I think you need to convert the date to text in 6

Enter Find Mode

Insert Calculated Result [ DateReqd, "≥" & DateToText( Status(CurrentDate)) ]

[ Select entire contents ]

Perform Find

[ Replace Found Set ]

HTH

Lee

[LaRetta]

Yes, thanks for the catch, Lee. Vs. 6 seems like centuries ago. :wink2:

[ngowran]

great thanks!!

the last one did the trick.