• 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

http://.../fmi/xml/fmresultset.xml?-db=elected_officials_sync&-lay=elected_officials&-find&date_modified=03252006&date_modified.op=gt&-max=100

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?
0
alisman
Asked:
alisman
1 Solution
 
lesouefCommented:
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
0
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