DATE COMPARISION in Transformer

[Billyqing]

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

Code: Select all

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

[ray.wurlod]

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.

[Rajender]

Hi Ray & Billy,

Thanks a Ton It works :D

Cheers
raj