Learn how to a build a cloud-first strategyRegister Now


Filemaker 7 query with date/time parameter

Posted on 2006-03-24
Medium Priority
Last Modified: 2010-04-27
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?
Question by:alisman
1 Comment
LVL 28

Accepted Solution

lesouef earned 200 total points
ID: 16283144
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Suggested Courses
Course of the Month21 days, 3 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question