topic IF AND IF THEN ELSE END IF - UGH it's not working! in Alteryx Designer Desktop Discussions

IF AND IF THEN ELSE END IF - UGH it's not working!

MaryCann — Tue, 22 Nov 2022 16:14:09 GMT

The formula cannot be this difficult! And I don't want my boss to know I can't figure it out. So, you folks! What is wrong with the below formula?

Supposedly it's a Malformed If Statement...

ShankerV — Tue, 22 Nov 2022 16:15:46 GMT

You have used 2 IF, you need to use only 1 IF.

Many thanks

Shaker V

Luke_C — Tue, 22 Nov 2022 16:16:31 GMT

Hi @MaryCann change your AND IF to just AND

IraWatt — Tue, 22 Nov 2022 16:16:38 GMT

You don't need the second IF statement should just start:

IF [Prescription End Date] >= DateTimeTodya() and [Client.....

MaryCann — Tue, 22 Nov 2022 16:16:48 GMT

OMG! Thank you @ShankerV !

ShankerV — Tue, 22 Nov 2022 16:16:53 GMT

IF (condition 1 AND condition 2)
then
else
endif

Many thanks

Shanker V

ShankerV — Tue, 22 Nov 2022 16:18:22 GMT

Welcome, happy to help!!!

Many thanks

Shanker V