R: Re: I: Change the date format in a notify filter.

2013-12-06 Thread Marek Ceizel
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: R: Re: I: Change the date format in a notify filter.

2013-12-06 Thread Marek Ceizel
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.

2013-12-06 Thread team.rem...@libero.it
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: 
>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: 
>>>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"