Date addition in a constraint

Benny Domeij · Post by **Benny Domeij** » Mon Oct 20, 2008 8:12 am

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?

Benny Domeij · Post by **Benny Domeij** » Mon Oct 20, 2008 8:16 am

The format of renewal_date and valid_to_date are "2008-08-01"...

ArndW · Post by **ArndW** » Mon Oct 20, 2008 11:05 am

StringToDecimal('2008-01-01') does not result in that which you are looking for. Try JulianDayFromDate to get an integer.