Re: [Arsperl-users] Inserting a date in ARSPerl

[Thilo S. <thi...@ap...>]

Unfortunately, date fields (unlike date/time fields) are only supported 
since ARSperl version 1.90

The value has to be an integer which can be computed from an epoch 
timestamp by

int( $epoch_time / 86400 ) + 2440588


Regards,
Thilo Stapff


Pittman, Timothy wrote:
> 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 = ars_CreateEntry($ctrl, $shopSchema, 
> 		$sf{"Description"}, $details,
> 		... various fields you don't care about...
> 		$sf{"Date Required"}, "$date1", 
> 		... more fields...
> 		$sf{"Status"}, "Submitted")) 
> 		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: 
> 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
> 
> ========================================================================
> 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.
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>