• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Filemaker 7 query with date/time parameter

I am submitting a query to the Filemaker 7 web publshing engine.  everything is working fine, but I need to submit a query which compares a date to a datetime field.    here is the query i've written


i can't figure out how to format the date properly and can't find any documentation on this.  what is the right syntax for this puppy?
1 Solution
using the regular fm client, you need to format the comparison string as a timestamp format, ie:
>= 03/25/2006 00:00:00,*
using the web access, the date seems to be different, but there must be something for time as well in a timestamp search.
cheap altenative:
create an extra field = date (datetime) and search in this one
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now