RE: [Arsperl-users] Querying by dates?

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

Sorry, I have not done a lot of Perl for many years and I am very rusty
and most likely not up to date. You suggests are lost on me. I really
don't understand.
=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

=20

________________________________

From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Richard Hellier
Sent: Thursday, October 13, 2005 1:30 PM
To: ars...@ar...
Subject: Re: [Arsperl-users] Querying by dates?


Mitch,
    The short answer is:  Remedy only understands one of your date
formats! I usually use dates like "20 September 2005" but you can just
embed the $TIMESTAMP$ "macro" if you want.

    BTW, try using Perl's qq{} operator which allows you to create
double quoted strings without having to bother with escaping any
intervening double quotes.

Good Luck!

Richard.


Lintner, Mitchell wrote:=20


	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