Date Time Attribute Vs Date

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
denisv
Posts: 253
Joined: Thu Jan 19, 2006 4:36 pm
Location: Ireland
Contact:

Date Time Attribute Vs Date

Post by denisv »

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 ?
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Post by aware_support »

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
Aware IM Support Team
Post Reply