Less than/Equal IF statement

Answered

Follow

Brendan O'Donoghue

• September 23, 2019 13:16

Hello Datameer Support,

For my first condition below, im looking to add an less than or equal to (< = 1700-01-01) to my date format

Can you please advise correct format to allow this to work?

IF(ISBLANK(#effective_date); 'NA'; IF(BEFORE(#effective_date; ASDATE('1700-01-01 00:00:00'));'Invalid';'Valid'))

IF(ISBLANK(#effective_date);"NA"; IF(BEFORE(#effective_date; TODAY());"Valid";"Invalid"))

IF(AND(EQUALS(#Validation!C_99_effective_date;'Valid');EQUALS(#Validation!C_100_effective_date;'Valid'));"Valid"; "Invalid")

0

• Official comment

  

  Alan

  • October 30, 2019 18:01
  • Edited

  Hi Brendan,

  Sorry for the late response, it seems there was a Zendesk email notification outage the day you posted this!

  I tested and was able to get the desired result with syntax like in your first example:

  IF(ISBLANK(#Sheet!datecolumn);'NA';IF(BEFORE(#Sheet!datecolumn;ASDATE('2019-01-01 00:00:00'));'Before';'After'))

  Please let us know if you have any further questions.

  Alan

  Comment actions Permalink

Please sign in to leave a comment.