DSXchange

I have defined the parameter date_2nd_month the value 2008-07-31 as a string and in a transformer I've created the variable valid_to_villkor as a date with the expression StringToDate("#date_2nd_month#"). Why am I getting the output ***** to that variable?

I wonder why this expression only give me 'N' for column forny although I get rows with different valid_from_date2 and valid_from_date:
if DSLink247.valid_from_date2<>DSLink247.valid_from_date then 'J' else 'N'

valid_from_date2 and valid_from_date are in date format.

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

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...

I get this error message:

Filter_131: Parse error: Expected comparison, 'between', or 'like' operator, got: "["
Parse error: Expected boolean operator (and, or) got: "1".

I have trouble with an index function in a filter. The where condition is: INDEX('KM,CM,',produktomr:',',1) =1 I want only rows from the column produktomr that is equal to KM or CM. I have seen a post in the forum that discusses solutions with locate and findstr, but I found those solutions hard to ...