Reply to comment

date/time fields filter only on date portion

Submitted by sshearin on Fri, 03/23/2012 - 09:46.

Hi Suresh --

Thanks for writing! I did some testing of my own, and it looks like the options to filter on a Date/Time type field like Last Modified are limited to dates only -- there are no options to filter on the time part of the field. I've also brought this to the attention of the development team, so perhaps that won't always be the case.

I suspect you could get around this limitation by creating a formula field to extract the time portion of the Last Modified field, then filtering by that field.

Regards,

--Sybil

Reply

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

date/time fields filter only on date portion

Reply

Browse by Category

Knowledge Base Categories

Formula Category

The QuickBase Blog

Online Database Software:

Company Information:

Site Links:

From the Makers of: