Syntax Error for Date

Follow

Brendan O'Donoghue

• July 26, 2019 15:23

Hello

Datameer newbie here and getting syntax errors for the below conditions.

Is there something wrong with the date formats ?

Any help would be great, thanks Brendan

IF(ISBLANK(#Validation!expiration_date); "NA"; IF (#Validation!expiration_date; >= "2199-12-31 00:00:00" );"Invalid"; "Valid"))

IF( OR(#Validation!C_96_expiration_date == "Invalid"); "Invalid"; "Valid" )

IF(ISBLANK(#Validation!effective_date); "NA"; IF (#Validation!effective_date; <= "1700-01-01 00:00:00" );"Invalid"; "Valid")) IF(ISBLANK(#Validation!effective_date);"NA"; IF(#Validation!effective_date <= TODAY();"Valid";"Invalid")) IF( OR(#Validation!C_99_effective_date == "Invalid"; #Validation!C_100_effective_date == "Invalid"); "Invalid"; "Valid" )

 

1

• 

  Konsta Danyliuk

  • July 26, 2019 15:55

  Hello Brendan.

  • Are you facing syntax errors for any of these formulas?
  • Whether all the columns involved in these formulas have DATE format?

  0

  Comment actions Permalink

Please sign in to leave a comment.