I'm trying to have a constraint that does the following:
StringToDecimal(StageVar) <= StringToDecimal(StageVar1) +1
The two stage variables have these codes:
StageVar1 DateToString(DSLink247.valid_to_date)
StageVar DateToString(DSLink247.renewal_date)
I have also made two columns to check the values in StageVar1 and StageVar:
renewal_date2 Integer 8 StringToDecimal(StageVar)
valid_to_date2 Integer 8 StringToDecimal(StageVar1) +1
But I just get 1 and 0 in the columns, why and how do I solve this?
Date addition in a constraint
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Mon Mar 07, 2005 2:43 am
-
- Participant
- Posts: 6
- Joined: Mon Mar 07, 2005 2:43 am
StringToDecimal('2008-01-01') does not result in that which you are looking for. Try JulianDayFromDate to get an integer.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>