Global field - insert calculated result

[KLA]

ok. I have these two GLOBAL DATE FIELDS that i'm using to perform a find for a RANGE of dates. On a layout, i enter the start date in one field and the end date in another. My script goes to the find mode in another layout and pastes these dates in my Date field via Insert Calculated Result - which i set up as (field one & "..." & field two). When i perform the script it gets to the pasting and then tells me that the field has to be in a date format only (it's inserting other numbers that i can't figure where from) - It's not taking my calculated result . My global fields are both set up as dates (and have to be 'cause it affects date format in other layouts - it does work if it's a text field). So, how can i find for a range using a global field? IT's ALMOST WORKING!! HELP, PLEASE!!

[Steven H. Blackwell]

You will need to coerce the date to a text string resembling the date:

2/5/2001 for example. When you type that into a DATE field, FIleMAker Proa actually records it as an integer representing the date.

I suppose you could use global text fields instead, but you';d have to be sure the user didn't put something like "Fourth of July" into the field.

Check out the Date Functions to see how to break out the month, day, and year.

HTH

Old Advance Man