Less than/Equal IF statement
AnsweredHello 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")
-
Official comment
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
Please sign in to leave a comment.
Comments
1 comment