I: Change the date format in a notify filter.
Hi All, Now we are trying to create a filter that executes the set function : DATENUM(dd, $Reported Date$) + . + DATENUM(mm, $Reported Date$) + . + YEAR(, $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/) to “12/11/2013 12:12:18” (gg/mm/). 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
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(, $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/) to “12/11/2013 12:12:18” (gg/mm/). 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
R: Re: I: Change the date format in a notify filter.
Hi Misi, ((DATENUM (dd, $ Reported Date $) + /) + DATENUM (mm, $ Date $ shown)) + /) + DATENUM (, $ 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(, $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/) to “12/11/2013 12:12:18” (gg/mm/). 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
Re: R: Re: I: Change the date format in a notify filter.
Hi, What about LPAD(DATENUM (dd, $ Reported Date $), 2, 0) ? But I'm not sure if I didn't forget something :) regards Marek ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
R: Re: I: Change the date format in a notify filter.
Maybe it must be like this : LPAD(DATENUM (dd, $ Reported Date $), 2, 00) give it a try. regards Marek ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: I: Change the date format in a notify filter.
Hi, Before changing the date, can u pls chk the AR System user preference form. there u hav an option to change the date time setting and chk the date time setting from server. Hope it will help. Thanks, Suresh L On Dec 6, 2013 2:42 PM, team.rem...@libero.it team.rem...@libero.it wrote: Hi All, Now we are trying to create a filter that executes the set function : DATENUM(dd, $Reported Date$) + . + DATENUM(mm, $Reported Date$) + . + YEAR(, $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/) to “12/11/2013 12:12:18” (gg/mm/). 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