Have any listers experienced problems using the DATEADD function with a
negative number? I'm trying to subtract 3 months from the current date and I
don't get the correct response.
In a filter I've set a date field using:
NewDate = DATEADD("month", -1, $OldDate$)
Today is January 12, 2015. When I trigger the above set fields action the
result is December 1, 2014. I expected December 12, 2014.
If I try to set it for 3 months ago [using DATEADD("month", -3, $OldDate$)] I
get October 3, 2014.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
