Finding records for a current month.

[Gregory_I]

I would like to set up a script to find records for the current month only. For Example: If I am running the script in September I would like all of the found records to be from September Only. How would I set this variable up in a Standard "Perform Find" script step or is there another way to do it? Maybee I can incorporate a calculation into a find somehow. Note: I do have fields setup within the record that are timestamped. This is the field data I will use for the finds.

Thanks

[Fitch]

FileMaker is pretty smart about finding dates. It's not quite as smart in letting you specify Find criteria in a single step. Instead you have to script it this way:

Enter Find Mode

  Set Field [theDate, Month(Get(CurrentDate)) & "/" & Year(Get(CurrentDate))]

Perform Find

See The Secret Life of Find Mode: Dates and Times for a full discussion of the topic.

[mr_vodka]

You can further shorten this up like this.

Enter Find Mode []

Set Field [ YourDate, Month ( Get ( CurrentDate ) ) ]

Perform Find []

FileMaker will assume its the current year.

[comment]

FileMaker will assume its the current year.

In a date field, yes - but not in a timestamp field.