Serch criteria

RT Users
1

Hi All

I have just started to use RT3 release 3.0.5

I try to use the date in the search criteria and the time is always
override, see ex:

ex: I want to select all tickets entered in the system between 19 and 22 of
sept 2003.

In the selection, I select Created > Before > 2003-09-23, and Created >
After > 2003-09-18

The system always include the time as 04:00:00

I try with Created > After > 2003-09-18 24:00:00 and the time is overridden
by 04:00:00, WHY?

Thanks for your help

Réjean Chartier

Directeur Centre d’expertise et de support SAP

Director SAP Consulting and Support Center

Via Consultants Inc.

SAP Professionals Across Canada

261 rue Saint-Jacques, 5eme Etage

Montreal, Que, H2Y 1M6

Tel: 1-514-494-3262

Cel: 1-514-605-6200

Fax: 1-514-494-2665

Free: 1-888-VIA-3227

mailto:rchartier@viaconsultants.com rchartier@viaconsultants.com

2

Rejean Chartier wrote:

Hi All

I have just started to use RT3 release 3.0.5

I try to use the date in the search criteria and the time is always
override, see ex:

ex: I want to select all tickets entered in the system between 19 and
22 of sept 2003.

In the selection, I select Created > Before > 2003-09-23, and Created

After > 2003-09-18

The system always include the time as 04:00:00

I try with Created > After > 2003-09-18 24:00:00 and the time is
overridden by 04:00:00, WHY?

Thanks for your help

SetToMidnight uses GMT (gmtime perl function). And as I think you have +4.

3

Thanks for the help

Réjean Chartier
Directeur Centre d’expertise et de support SAP
Director SAP Consulting and Support Center
Via Consultants Inc.
SAP Professionals Across Canada
261 rue Saint-Jacques, 5eme Etage
Montreal, Que, H2Y 1M6
Tel: 1-514-494-3262
Cel: 1-514-605-6200
Fax: 1-514-494-2665
Free: 1-888-VIA-3227
rchartier@viaconsultants.comFrom: Ruslan U. Zakirov [mailto:cubic@acronis.ru]
Sent: 22 septembre, 2003 12:23
To: Rejean Chartier
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Serch criteria

Rejean Chartier wrote:

Hi All

I have just started to use RT3 release 3.0.5

I try to use the date in the search criteria and the time is always
override, see ex:

ex: I want to select all tickets entered in the system between 19 and
22 of sept 2003.

In the selection, I select Created > Before > 2003-09-23, and Created

After > 2003-09-18

The system always include the time as 04:00:00

I try with Created > After > 2003-09-18 24:00:00 and the time is
overridden by 04:00:00, WHY?

Thanks for your help

SetToMidnight uses GMT (gmtime perl function). And as I think you have +4.

4

Stefan Seiz wrote:>On 22.09.2003 18:05 Uhr, Rejean Chartier rchartier@viaconsultants.com wrote:

ex: I want to select all tickets entered in the system between 19 and 22 of
sept 2003.

In the selection, I select Created > Before > 2003-09-23, and Created > After

2003-09-18

The system always include the time as 04:00:00

I try with Created > After > 2003-09-18 24:00:00 and the time is overridden by
04:00:00, WHY?

Probably because dates in the database are stored as GMT Dates and your
timezone (RT Timezone) is 4 hours behind of GMT?

I have my own question on this where I could change offset? I have +3
instead of +4 as gmtime think.
Best regards. Ruslan.

5

Why is the time not specified in the Local time as in most other time
displays in RT?

Can the search for date include a date and time like “2003-09-18 14:00:00”.

Also this time should be taken as the local time.

Thanks,
Real-----Original Message-----
From: rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of Ruslan U. Zakirov Sent: Monday, September 22, 2003 12:23 PM To: Rejean Chartier Cc: rt-users@lists.fsck.com Subject: Re: [rt-users] Serch criteria Rejean Chartier wrote:

Hi All

I have just started to use RT3 release 3.0.5

I try to use the date in the search criteria and the time is always
override, see ex:

ex: I want to select all tickets entered in the system between 19 and
22 of sept 2003.

In the selection, I select Created > Before > 2003-09-23, and Created

After > 2003-09-18

The system always include the time as 04:00:00

I try with Created > After > 2003-09-18 24:00:00 and the time is
overridden by 04:00:00, WHY?

Thanks for your help

SetToMidnight uses GMT (gmtime perl function). And as I think you have +4.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm