Just wanted to pass this along...
ARS 6.3 p22 (server, mid-tier, user tool), SQL Server 2000 (all patches), Windows Server 2003 (all patches). When passing a date in a date field within an active link to a Set Fields SQL User Defined Function Remedy changes the date to the previous day. This only occurs for dates starting this last Sunday through this coming Sunday. The work-around is to set the date field to a tmp character field first, then pass the tmp character field to the SQL user defined function. HTH Stephen Remedy Skilled Professional ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 01, 2007 5:09 PM To: arslist@ARSLIST.ORG Subject: Re: Possible DST Issue Wow! That's weird. Does that happen from the native client too? Just for information purposes - what if you save it on the mid tier and then view the record from the mid-tier? What is the date displayed as? Also if you save from the native client does it display it correctly on the mid-tier? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Suwanski, Ron Sent: Thursday, November 01, 2007 4:25 PM To: arslist@ARSLIST.ORG Subject: Re: Possible DST Issue ** Yes I saw it too.. but it was only for 11/1/2007. If you try 11/2/2007 it is fine.. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, November 01, 2007 12:51 PM To: arslist@ARSLIST.ORG Subject: Possible DST Issue ** ARS 6.3 p20 Solairs\Sybase MidTier p20 Apache\TomCat TZ:EST Have a form with a date (not date time) field. User enters the date 11/01/2007. When they save the record the MidTier is changing the date to 10/31/2007. I was not able to find any way of setting 11/1/2007 in that field. Also, if I enter the date as "11/1/2007 4:00:00 PM" it puts 11/0/2007 as the date. Anybody else seeing this scenario? Thank you Frank __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"