[Arsperl-users] Inserting a date in ARSPerl

[Pittman, T. <Tim...@re...>]

I have been having considerable difficulty trying to use ARSPerl to
create an entry with a date.  My web page is prompting the user to enter
a date, which I'm assuming will be in the format mm/dd/yyyy.  I am using
the perl module ParseDate to attempt to figure out what they enter.  In
any case, I need to convert this user-entered value into some format
that ars_CreateEntry can deal with.  My code does this:

	($entryId =3D ars_CreateEntry($ctrl, $shopSchema,=20
		$sf{"Description"}, $details,
		... various fields you don't care about...
		$sf{"Date Required"}, "$date1",=20
		... more fields...
		$sf{"Status"}, "Submitted"))=20
		or print  "\n<p>[ERROR]\tCould not add shop order due to
$ars_errstr<b><br>\n";

I have tried numerous ways of formatting the date field $date1 above to
attempt to get it to shop up in the proper format in Remedy.  I have
tried numerous variations of the following:=20
A string (i.e. "10/17/2007")
An integer (converted via timelocal and others to epoch time)

I either end up with the date 1/1/9999 or 1/1/4713 B.C. in my date
field. I have searched everywhere on the net that I can find and nothing
has helped. Does anyone know what to do to a user-entered date to make
ars_CreateEntry accept it properly?

This is running on a Win2K server with ARSPerl 1.82 against a Remedy 6.0
system on Oracle.

Thanks, Tim

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
CONFIDENTIALITY NOTICE
----------------------
This message, together with any attachments, may be legally privileged
and is confidential information intended only for the use of the
individual or entity to which it is addressed.  It is exempt from
disclosure under applicable law including court orders.  If you are not
the intended recipient, you are hereby notified that any use,
dissemination, distribution or copy of this message, or any attachment,
is strictly prohibited.  If you have received this message in error,
please notify the original sender and delete this message, along with
any attachments, from your computer.