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 (http://www.rrr.se) (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 (http://rrr.se) February 26, 2018 9:27 PM, "Keith Sinclair" 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
