Hi Misi, ((((((DATENUM ("dd", $ Reported Date $) + "/") + DATENUM ("mm", $ Date $ shown)) + "/") + DATENUM ("yyyy", $ Date Reported $)) + "") + (((HOUR ($ reported Date $) + ":") + MINUTE ($ reported Date $)) + ":")) + SECOND (reported Date $ $)
Produces this: 6/12/2013 10:41:57 You can see that the day is formatted with a single digit, is it possible to set the field with two digits? thanks in advance Peter >----Messaggio originale---- >Da: m...@rrr.se >Data: 6-dic-2013 10.29 >A: <arslist@ARSLIST.ORG> >Ogg: Re: I: Change the date format in a notify filter. > >Hi, > >I have not used DATENUM)= to any greater extent, but if it works your idea is >not bad. Just put it in a display-only-field that you use for this purpose >only. > >The alternative would be to change the date format for your complete AR >Server, but that might affect other things. This can be done by setting the >ARDATE, ARTIME and ARTIMEONLY environment variables in armonitor.conf. This >would not affect your clients, only the server and any date/time <-> text >conversions that are made. For example the $Reported Date$ to a text in an >email notification. > > Best Regards - Misi, RRR AB, 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. > >> Hi All, >> Now we are trying to create a filter that executes the set function : >> >> DATENUM("dd", $Reported Date$) + "." + DATENUM("mm", $Reported Date$) + "." + >> YEAR("yyyy", $Reported Date$) + " " + HOUR($Reported Date$) + ":" + MINUTE >> ($Reported Date$) + ":" + SECOND($Reported Date$) >> >> do you think is a good idea ? >> Bye >> Pietro >> >>>----Messaggio originale---- >>>Da: team.rem...@libero.it >>>Data: 12-nov-2013 13.07 >>>A: <arslist@arslist.org> >>>Ogg: Change the date format in a notify filter. >>> >>>Is it possible to change the date format in a notify filter ? >>>i.e. I need to translate a date from “11/12/2013 12:12:18 PM” >>> (mm/gg/yyyy) >> to >>>“12/11/2013 12:12:18” (gg/mm/yyyy). >>> >>>Can you help me ? >>>Thanks in advance. >>>Pietro >>> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" >> > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >"Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"