John, you need to be very careful when dealing with date vs date/time. Date stores the # of days....date/time stores the # of seconds. What you are trying to do is add date/time (seconds in 15 days) to a purported date field....you may want to just try adding 15....but be warned, there have been problems using calculation on date fields with $DATE$...so you might be better off setting your date field to $DATE$, then in a second setfield action (same AL works) do a $DateField$+15
_____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: Monday, December 07, 2009 11:44 AM To: arslist@ARSLIST.ORG Subject: Date field viewed in Dialog form on midtier Hi list Have a slight bug calculating a date field on a midtier page through a dialog form. Has anyone had this before and know if its a bug? I have a link that opens a form in a dialog view with a Date field that is supposed to set the date 15 days later than the DATE. My Qualification : $DATE$ + (((60 * 60) * 24) * 15) for the field on Open Window. The issue is, the midtier shows the date 1/1/9999. The weird thing is the date is calculated properly when opening the form throught the client. I flushed the cache many times and deleted local temps. Just wandering if there is a Midtier bug calculating Dates on an Open Window action in a dialog view ? Midtier 7.1 patch 6 ARS 7.1 Oracle 10g JK ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
