Hi Misi, I did try the DATE + 15 and that seemed to work for the purposes I need. Great suggestion!
I am going to also try the integer method in my sandbox later. From: ARSList [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Monday, February 26, 2018 3:06 PM To: ARSList <[email protected]> Subject: Re: Application-Bus-Time-Add Issue Hi, I typically pass a date/time-field into an integer and then use the integer field in the $PROCESS$. This prevents problem with date/time formats. And according to the result it might not be a date/time-field, it might be a date-field which might work differently. Have you tried ($S0 Date$ + 15) instead of the $PROCESS$ thing? Best Regards - Misi, RRR AB, http://www.rrr.se<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rrr.se&data=02%7C01%7Cksinclair%40shoppertrak.com%7C2c7a51fd89e24bbaa7dd08d57d5d08ca%7Ca1f1e2147ded45b681a19e8ae3459641%7C0%7C1%7C636552760906873746&sdata=IMBRdewgYrtv57XxV8yWrKUXBOX2oHHolp8ggSCFiiQ%3D&reserved=0> (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Frrr.se&data=02%7C01%7Cksinclair%40shoppertrak.com%7C2c7a51fd89e24bbaa7dd08d57d5d08ca%7Ca1f1e2147ded45b681a19e8ae3459641%7C0%7C1%7C636552760906873746&sdata=uY9l4XSh04cBuGm%2BpRez%2B0A7yPvNOKg4UznKBNDPiDw%3D&reserved=0> February 26, 2018 9:27 PM, "Keith Sinclair" <[email protected]<mailto:%22keith%20sinclair%22%20%[email protected]%3e>> wrote: List, I am trying to add 15 days to a date field on a filter and it keeps displaying a date of 1/1/9999. What am I doing wrong? Set field syntax: $PROCESS$ Application-Bus-Time-Add "$S0 Date$" "15" "4" Driving me nuts! Any help is appreciated. Specs: ARS: 8.1.2 DB: Oracle 11g OS: CentOS
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
