date field in a calculation

[icefield]

hi folks, i am trying to set up a calculation field (fm4) that will change an amount due based upon the record creation date. the calculat[ion does not seem to care for the date in dd/mm/yyyy format. here's my calculation:

If(required2002 Convocation Honoree = "Senior Associate 2001-2002" or required2002 Convocation Honoree = "Leadership Associate 2001-2002" or Date ? "11/30/2001", "195", "225")

no matter what i do, the amount is still "225" even though the creation date of any record i enter is prior to 11/30/2001.

please help!

ezra

[icefield]

sorry the ? (in the calculation i copied into the post) is actually <= ........

[spb]

I had a similar problem. The solution was to make another field, a calculation field that takes the contents of the "Date" field (which I presume is a record creation field that is automatically filled) and runs the DateToText calculation step on it. This takes the date out of Filemaker's internal date storage format (which has foiled many a script) and converts it to the text version you actually see on the screen. Then change your script to reference this new field.

I hope I haven't steered you wrong here. I'm fairly inexperienced, but this is a solution that worked for me.

[icefield]

thansk steve!

i'll give it a shot......

best regards,

ezra

[Thom]

Use the Date() function, like this:

Date (month, day, year)

or, in your case:

Date(11,30,2001)