[Arsperl-users] Querying by dates?

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

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

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

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
It finds the necessary records.

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

Thanks,

Mitch

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