DSXchange

Posted: **Tue Oct 26, 2004 1:35 pm**

Your date format is not "D/E", but "DDMY[2,2,4]"

@Date> Iconv(Ln_Histor_Data_In.FICHE_DEBUT_VALIDITE_CH, "D/E") And @Date < Iconv('Ln_Histor_Data_In.FICHE_FIN_VALIDITE_CH', "D/E")

Try This:

Code: Select all

@Date> Iconv(Ln_Histor_Data_In.FICHE_DEBUT_VALIDITE_CH, "DDMY[2,2,4]") And @Date < Iconv('Ln_Histor_Data_In.FICHE_FIN_VALIDITE_CH, "DDMY[2,2,4]")

If it still does not work, you should make sure that your date met the constrain.

Posted: **Tue Oct 26, 2004 4:06 pm**

Welcome aboard! :D

"DDMY" will be sufficient with Iconv(). See Date Conversion Demystified to learn why this is. Therefore your expression can be

Code: Select all

@DATE > Iconv(Ln_Histor_Data_In.FICHE_DEBUT_VALIDITE_CH, "DDMY") And @DATE < Iconv(Ln_Histor_Data_In.FICHE_FIN_VALIDITE_CH, "DDMY")

Note also that the column name in the second Iconv() is not to be quoted; if it is you are trying to convert that string, rather than the column name.

Posted: **Wed Oct 27, 2004 9:21 am**

Hi Ray & Billy,

Thanks a Ton It works :D

Cheers
raj

DSXchange

DATE COMPARISION in Transformer