Re: [Arsperl-users] Querying by dates?

[Jeff M. <jcm...@je...>]

On Thu, 2005-10-13 at 13:49 -0400, Lintner, Mitchell wrote:
> 
> I am having trouble getting a ARSPERL script to query with dates. Can
> you suggest what I am doing wrong?
> 
> $query = "('Approver CUID' = \"$approver_cuid\" AND 'Start Time' <=
> \"$time\" AND 'End Time' >= \"$time\")"; 
> %alternates=doquery($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.
> 

try setting ARDATE .. the script is probably using some default date
format that doesnt match what you are providing...

BEGIN {
	$ENV{'ARDATE'} = "%Y/%m/%d"; # ....
}

i think the format characters are the same as what are listed in the
"strftime" man page.

jeff



> 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...