Filemaker 7 query with date/time parameter

Posted on 2006-03-24
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

    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    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…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now