Smiple Find and IF script...help a newbie

[Leb i Sol]

hello People!

I am compleatly new to scripting deal = I know nothing !

Here is what I am trying to do:

- Sort records based on field called "UPS Date" based on logic that the content of it is either empty or > than CurrentDay

I "attempted" to write it out but no cigar

-----------------------------------

Go to Layout ["Waiting List"]

Enter Find Mode[]

Go to Field ["UPS date"]

Insert Text [select,"UPs date",">CurrentDate"]

Pefrom Find[Restore,Repleace Found Set]

--------------------------------------------------------this is it

as I said I really dont know anything about scripts but that they are "nice"....if someone could help that would be "nice"

thank you guys!

[BobWeaver]

Try this instead:

Go to Layout ["Waiting List"]

Enter Find Mode[]

#Shouldn't need the go to field step because you specify

# it in the Insert Text step

Insert Text [select,"UPs date",">CurrentDate"]

New Record/Request

Insert Text [select, "UPS date","="]

#Note, don't select "restore" in the following perform find step

Pefrom Find[Replace Found Set] 

[Leb i Sol]

....still no cigar....the ">CurrentDate" gets inserted as text rather than a ">1/1/2002" form of a date and script stops?

[Ugo DI LUCA]

Hi Leb i Sol,

I really don't understand why it doesn't work with the Status(Current date) but have a try with a global field.

Go to Layout ["Waiting List"]

Set field (g_current date, Status(Current date))

Enter Find Mode[]

Insert Text [select,"UPs date",">g_current date"]

New Record/Request

Insert Text [select, "UPS date","="]

Pefrom Find[Replace Found Set]

[Leb i Sol]

I dont know what to say either....here is a screenshot attached

g_current date = g_currentdate on my screen

[BobWeaver]

Oh, I should have looked at your script a little closer. Try this:

Go to Layout ["Waiting List"]

Enter Find Mode[]

#Shouldn't need the go to field step because you specify

# it in the Insert Text step

Insert Calculated Result [ Select, UPS date, ">"& DateToText(Status(CurrentDate)) ]

New Record/Request

Insert Text [select, UPS date,"="]

#Note, don't select "restore" in the following perform find step

Pefrom Find[Replace Found Set] 

[Leb i Sol]

great this worked like a dream!

thanx agin!

[Ugo DI LUCA]

">" for sure