Date Ranges

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
joftech
Posts: 117
Joined: Thu Oct 19, 2006 10:42 am
Location: Sydney
Contact:

Date Ranges

Post by joftech »

Hi Support,

How does one setup a system to be able to search by a date range

ie

1/1/2006 to 1/3/2006


thanks

Alan
aware_support
Posts: 7526
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Post by aware_support »

Define a query:

FIND Object WHERE Object.Date < 01/03/2006 AND Object.Date > 01/01/2006
Aware IM Support Team
joftech
Posts: 117
Joined: Thu Oct 19, 2006 10:42 am
Location: Sydney
Contact:

Post by joftech »

HI,

But how to I get the system to ask the user to enter the date ranges.

ie from date 1 to date 2.

Alan
aware_support
Posts: 7526
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Post by aware_support »

Aware IM User Guide. Section "Queries that require user input".

Please familiarize yourself with the Aware IM User Guide.
Aware IM Support Team
joftech
Posts: 117
Joined: Thu Oct 19, 2006 10:42 am
Location: Sydney
Contact:

Date Ranges

Post by joftech »

Hi Support,

I am still having a problem with getting the system to prompt the user for date ranges.

I have setup a Quiry that looks like this.

FIND Invoice WHERE Invoice.Date<? AND Invoice.Date>?

It does not give a from date to dat option. What am I doing wrong.

Thanks

Alan
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:

Post by aware_support2 »

Hi Alan,

You need to add labels to the prompts, for example:

FIND Invoice WHERE Invoice.Date<?'To Date' AND Invoice.Date>?'From Date'
Aware IM Support Team
joftech
Posts: 117
Joined: Thu Oct 19, 2006 10:42 am
Location: Sydney
Contact:

Post by joftech »

Thank you support. That was stupid of me.

Alan
Post Reply