RE: [Arsperl-users] Querying by dates?

[Lintner, M. <mit...@ci...>]

Thanks,
=20
I just did do this and it works fine.
=20

Mitch Lintner=20
Analyst/Programmer=20
Remedy Developer=20
Cingular Wireless=20
1125 E Campbell Rd=20
Richardson, Texas, 75081=20
972-907-6965=20
mit...@sw...=20

=20

________________________________

From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Das, Manojit
Sent: Thursday, October 13, 2005 2:28 PM
To: ars...@ar...
Subject: RE: [Arsperl-users] Querying by dates?


Mitch,
How about this.
Before you do Run process
Do a setfield action and set $time-integer =3D $time  (this will put
integer value in $time-integer (integer field you need to create))
=20
Now do
$query =3D "('Approver CUID' =3D \"$approver_cuid\" AND 'Start Time' =
<=3D
\"$time-integer \" AND 'End Time' >=3D \"$time-integer \")";=20
%alternates=3Ddoquery($ctrl,$schema,$query);=20
=20
=20
Thanks,
Mano

________________________________

From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Lintner, Mitchell
Sent: Thursday, October 13, 2005 12:49 PM
To: ars...@ar...
Subject: [Arsperl-users] Querying by dates?




I am having trouble getting a ARSPERL script to query with dates. Can
you suggest what I am doing wrong?=20

$query =3D "('Approver CUID' =3D \"$approver_cuid\" AND 'Start Time' =
<=3D
\"$time\" AND 'End Time' >=3D \"$time\")";=20
%alternates=3Ddoquery($ctrl,$schema,$query);=20

If I give $time a value of "10/13/05 10:42:03", the script does not find
anything. If I set $time equal to 1129220941=20
It finds the necessary records.=20

I want to call this script from a Run Process and pass it the
$TIMESTAMP$ value.=20

Thanks,=20

Mitch=20

Mitch Lintner=20
Analyst/Programmer=20
Remedy Developer=20
Cingular Wireless=20
1125 E Campbell Rd=20
Richardson, Texas, 75081=20
972-907-6965=20
mit...@sw...=20