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

[Domino1]

  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 ?

[vchuprina · Accepted solution]

Hi,

If (StartMonth > EndMonth , 0 ,

   If (StartMonth = EndMonth, 0,

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

Regards,

Vitalii