Date Time Attribute Vs Date
Date Time Attribute Vs Date
I have a business object that has a start and end (date)time value. I want to be able to run a query (/report) where the date portion only is entered at run time and all matching rows are returned. Can you advise ?
-
- Posts: 7532
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Make sure that you download the latest build (743) which has support for the DATE_PART function. Specify a query like this (in the Rule Language format):
FIND Object WHERE DATE_PART (Object.Time) = ?'Date'
The ?'Date" is interpreted as entered at run-time with the "Date:" prompt.
Best Regards
FIND Object WHERE DATE_PART (Object.Time) = ?'Date'
The ?'Date" is interpreted as entered at run-time with the "Date:" prompt.
Best Regards
Aware IM Support Team