I would append a text field near the second date/time fields with the following value : "till this date/time excluded -- time defaults to 00:00:00 if not specified", and that's it !
Users have to understand exactly how your tool works, and what they want.







CHUG@BRIERES.FAURECIA.COM on 08/11/99 11:23:00
Pour : ARSLIST@LISTSERV.VISTAIT.COM@hub
cc : (ccc : Boris BLAZEJCZAK/STI/EMC/EDFGDF/FR)
Objet : Upper Date

Hello,

I'm sure some of you can help me on this one...
I am using a display form, containing two date/time fields (date1 and
date2), and a button that fires a macro.
The macro uses date1 & date2 as parameters. It extracts tickets created
between date1 and date2.
Here's the problem :
The user can type date2 as "dd/mm/yyyy hh:mm:ss". In that case it works
fine.
He can also type it as "dd/mm/yyyy". In that case "hh:mm:ss" defaults to
"00:00:00". So date2 itself is not taken into account in the interval,
although the user probably wanted to include it. For example, if I want to
extract tickets created between "01/11/1999" and "10/11/1999", I want to
include the tickets created on "10/11/1999".
I guess it will take hidden fields and "set fields" actions, but I wanted to
ask you for the best way to do this.

Thank you.

=========================================
Christophe Hug (SoluCom)
chug@brieres.faurecia.com
=========================================

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

include all of the tickets on that date. So you would have 'Create-date' <
$Date2$ + (24*60*60)

Todd Lazar
Remedy Administrator
GTE Enterprise Solutions
Phone: 813-483-8182
Mobile: 813-230-1364


-----Original Message-----
From: Boris BLAZEJCZAK [mailto:Boris.Blazejczak@EDFGDF.FR]
Sent: Monday, November 08, 1999 6:39 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Réf. : Upper Date


Hello Christophe,

I would append a text field near the second date/time fields with the
following value : "till this date/time excluded -- time defaults to 00:00:00
if not specified", and that's it !
Users have to understand exactly how your tool works, and what they want.







CHUG@BRIERES.FAURECIA.COM on 08/11/99 11:23:00
Pour : ARSLIST@LISTSERV.VISTAIT.COM@hub
cc : (ccc : Boris BLAZEJCZAK/STI/EMC/EDFGDF/FR)
Objet : Upper Date

Hello,

I'm sure some of you can help me on this one...
I am using a display form, containing two date/time fields (date1 and
date2), and a button that fires a macro.
The macro uses date1 & date2 as parameters. It extracts tickets created
between date1 and date2.
Here's the problem :
The user can type date2 as "dd/mm/yyyy hh:mm:ss". In that case it works
fine.
He can also type it as "dd/mm/yyyy". In that case "hh:mm:ss" defaults to
"00:00:00". So date2 itself is not taken into account in the interval,
although the user probably wanted to include it. For example, if I want to
extract tickets created between "01/11/1999" and "10/11/1999", I want to
include the tickets created on "10/11/1999".
I guess it will take hidden fields and "set fields" actions, but I wanted to
ask you for the best way to do this.

Thank you.

=========================================
Christophe Hug (SoluCom)
chug@brieres.faurecia.com
=========================================

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Yes I'll guess I'll do something like that. But only if the "hour" field of
the date is NULL (that is, it was left empty).
Thanks Todd.
About the other answer I got, from Boris : sorry Boris, that is exactly what
I don't want to do. The tool has do adapt to the users, not the opposite.
And that rule is not specific to ARS... Thanks anyway for thinking about it.

Chris

=========================================
Christophe Hug (SoluCom)
chug@brieres.faurecia.com
=========================================

> -----Message d'origine-----
> De: Todd Lazar [SMTP:tlazar@GTE-ES.COM]
> Date: lundi 8 novembre 1999 13:56
> À: ARSLIST@LISTSERV.VISTAIT.COM
> Objet: RE: Réf. : Upper Date
>
> Why not in your query macro add 24 hours of time to it so that it will
> include all of the tickets on that date. So you would have 'Create-date'
> <
> $Date2$ + (24*60*60)
>
> Todd Lazar
> Remedy Administrator
> GTE Enterprise Solutions
> Phone: 813-483-8182
> Mobile: 813-230-1364
>
>
> -----Original Message-----
> From: Boris BLAZEJCZAK [mailto:Boris.Blazejczak@EDFGDF.FR]
> Sent: Monday, November 08, 1999 6:39 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Réf. : Upper Date
>
>
> Hello Christophe,
>
> I would append a text field near the second date/time fields with the
> following value : "till this date/time excluded -- time defaults to
> 00:00:00
> if not specified", and that's it !
> Users have to understand exactly how your tool works, and what they want.
>
>
>
>
>
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist