2. ASPRunnerPro General questions
  3. Date field search
This topic is locked

Date field search

 		6/7/2004 9:43:09 AM
ASPRunnerPro General questions
A
 aontech author

I am connected to an Oracle database. When I attempt to search on a timestamp field, I do not return any results. The DataType in Oracle is Date (ex...5/17/2004 6:05:08 AM). I want to return results based on the month and day.
I have tried using both blank and Short Date in the "View As" field, but no luck. Do I need to remove the time from the date field in order to get the search function to work, or is it something else?
Sergey Kornilov admin 6/8/2004

First of all - "View as" type has nothing to do with search. This is just a way of information representation on the list page.
I guess you need to change this field type from DateTime to Date (no seconds after date value).
E
 		evileyez3 6/26/2007

I am connected to an Oracle database. When I attempt to search on a timestamp field, I do not return any results. The DataType in Oracle is Date (ex...5/17/2004 6:05:08 AM). I want to return results based on the month and day.

I have tried using both blank and Short Date in the "View As" field, but no luck. Do I need to remove the time from the date field in order to get the search function to work, or is it something else?


aontech - I feel your pain. I am using a MSSQL DB and get no results returned when searching the timestamp. The only work around I've been able to use, is going to Advanced searched and doing:
Okay I want to pull all records for 6/13
So I choose Between and then put 6/13/2007 and then 6/14/2007 into the fields. This will return all records from 6/13. Hope this helps.
Sergey Kornilov admin 6/26/2007

If you want to search on date you have the following options:

  1. Use Between search
  2. Use calculated field that extracts date value from the timestamp field
  3. Separate date and time storing it in two different fields.