> An easy way to do this is to use the multipliers. You will also need to > use $TIMESTAMP$ > > 'my_date_field' > ($TIMESTAMP$ + (60*60*24*182)) > > $TIMESTAMP$ returns the number of seconds elapsed since midnight > Coordinated Universal Time (UTC) of January 1, 1970. > > Guess what platform Remedy ARS was first built upon? That's right UNIX. > There used to be 3 clients. Anyone know what they were? Note: Remedy ARS > was built before there was a Public Internet. Come to think of it, there > may have been 4 clients at one time, but there may not have been one for > IBM OS/2. > > When you do it this way, you can substitute a $variable or a number > whenever you like.
I've tried that too, of course. When your my_date_field is a DATE field the example you're showing will n o t work. At least on my 6.3 patch 024 it just doesn't work. Thanks anyway! Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
