I have problems with date finds... Help!

[barracudaxxx]

Here are my fields:

"Date" is defined as a date field in File A

"gDate" is a global (date) field in File B

And this is what I'm trying to do:

Enter Find Mode []

Set Field ["Date", "">="&File B::gDate"]

Perform Find [Extend Found Set]

But I noticed that it instead inserts weird numbers with "/". What is the proper way to insert a " >= " in a date field?

Thanks,

Chard

[Lee Smith]

Hi Chard,

I have *not* tested this, but I think you need to use the TextToDate in your Set Field:

Try

Set Field ["Date", "">=" & TextToDate B::gDate"]

HTH

Lee

[Lee Smith]

p.s.

Make sure your gDate is formatted as a Date Field.

Lee

[barracudaxxx]

Hi Lee!

Nope, I tried the TextToDate function and checked that all fields are date fields and the other is a global date field, but it just inserts a "?" in the date field in Find Mode. Any other ideas? I'm really stuck with this thing.

Chard

[barracudaxxx]

Just an update on my problem. I don't know why, but I tried this:

Insert Calculated Result ["Date", "">=" & DateToText(File B::gDate)"]

But it works for me!

Does this mean you can't use Set Field when using "&" in Find Mode?

[-Queue-]

This is where Insert Calculated Result comes in. Any time you're setting a field with an expression that doesn't exactly equal the field's format (mostly date and time fields) use Insert Calculated Result. This will not try to force the result into a date or time format, as Set Field will.

Insert Calculated Result [Date, ">=" & DateToText(gDate)]

or Insert Calculated Result [Date, ">" & DateToText(gDate - 1)]

[Lee Smith]

Shot, I overlook that we were trying to set a date field.

You can't use "Set Field" with a Date, it has to be Insert Calculated result. I tested this one and it seems to do what you want.

Go to Layout [original layout]

Enter Find Mode []

Insert Calculated Result [select,