Is it possible to combine 3 'IF' statements into one flag ?

Domino1 — Mon, 18 Apr 2022 09:12:05 GMT

Below are 4 conditions as required:

1, If (StartMonth > EndMonth , 0,1 )

2, If (StartMonth = EndMonth, 0,1)

3. If ((StartMonth < EndMonth ) AND If (StartYear < EndYear ), 0, 1)

The AND function on #3 does not seem to work but no issues if I separate the the 2 conditions.

How can I combine ALL 3 conditions into 1 FLAG ?

Re: Is it possible to combine 3 'IF' statements into one flag ?

vchuprina — Mon, 18 Apr 2022 09:16:08 GMT

Hi,

If (StartMonth > EndMonth , 0 ,

If (StartMonth = EndMonth, 0,

If (StartMonth < EndMonth AND StartYear < EndYear , 0, 1))) AS Flag

Regards,

Vitalii