Using date and time fields on your search form

You might want to include a date and time field on a search form that you create for your users. For example:

From Date: [1258959600]

The date and time in this example are November 23, 2009, 12:00:00 A.M.

If you use the date and time in a filter query, send a normalized value and not the original date and time string through the filter. The normalized value is the same as the value on the AR System server.

Related topic

Setting-up-FTS-to-search-across-multiple-forms

To normalize the date and time value

  1. Include a hidden integer field on the form.

  2. If you have an event that constructs your filter query, create a Set Fields active link that copies the value of the date and time field to the hidden integer field.
    This causes the client to convert the date and time string to the appropriate integer value, which takes into account the locale and time zone of the client and normalizes it to the date and time used by the server.
    For example:

    Hidden_Integer [1250143200]

  3. Use the value of the hidden integer as the value of the date that you are passing.
    An example of the resulting filter query is as follows:

    'modifiedTime' >= "1250143200"

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*