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.