Mark,
Even if that did work, it wouldn't be always accurate, considering leap years
or the 2 consecutive months that we have 30 days.
Why not try string manupulation, by setting the current value contained in the
date field, to a character field and then find the month position and extract
the month part of the string, set that to a display only integer field, add 6
to it, and reconstruct the date string.. Consider the exception for when you
will need to add up the year part if the month part is greater than 6.
Also create exceptions for the month of February to handle leap years.
Might be tricky but you will end up with a more accurate result..
Cheers
Joe
________________________________
From: Mark Milke <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Monday, October 27, 2008 10:27:04 AM
Subject: Adding days to a Date field in a qualification doesn't work
Hi Listers,
I have a date field on my form and I want to check, if the date entered isn't
later than 6 months from now. I have an Active Link with the following
qualification:
'my_date_field' > $DATE$ + 182
This doesn't work.
'my_date_field' > $DATE$ works just fine. As soon as I try to add any number
the $DATE$ variable it stops working.
Why?
Mark
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
