Validating Date

[G SHIVARANJANI]

I have given this way

IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%m/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%d/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%m/%d/%yyyy"))

its giving error as :

APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%m/%dd/%yyyy" for conversion "date=date_from_string[%yyyy-%mm-%dd](string)": APT_Conversion_String_Date: Invalid Format [%m/%dd/%yyyy] used for string_from_date type conversion.

Why not use three IsValid() functions (with different date format strings) connected by OR ? ...

[G SHIVARANJANI]

I have given this way:

IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%m/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%d/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%m/%d/%yyyy"))

But its giving error:

APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%m/%dd/%yyyy" for conversion "date=date_from_string[%yyyy-%mm-%dd](string)": APT_Conversion_String_Date: Invalid Format [%m/%dd/%yyyy] used for string_from_date type conversion.

[mads_a]

does both the 'date' values that need to be passed in the below given function same? If yes, is it the input column name?

Use IsValid() function.
If your input date is not in date format you might want to convert it and use - IsValid('date',StringToDate(InputLink.Date,"%yyyy%mm%dd"))

[mads_a]

does both the 'date' values that need to be passed in the below given function same? If yes, is it the input column name?

Use IsValid() function.
If your input date is not in date format you might want to convert it and use - IsValid('date',StringToDate(InputLink.Date,"%yyyy%mm%dd"))