I: Change the date format in a notify filter.

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

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

2013-12-06 Thread Misi Mladoniczky
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

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

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

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

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: I: Change the date format in a notify filter.

2013-12-06 Thread Suresh Loganathan
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