Expression too complex...
IF (dwYear1 < dwYear2) OR _
(dwYear1 = dwYear2 AND _
(dwMonth1 < dwMonth2 OR _
(dwMonth1 = dwMonth2 AND _
((dwLeapMonth1 = %TRUE AND dwLeapMonth2 = %FALSE) OR _
(dwLeapMonth1 = dwLeapMonth2 AND _
(dwDay1 < dwDay2 OR _
(dwDay1 = dwDay2 AND _
(dwLeapDay1 = %FALSE OR dwLeapDay2 = %TRUE)))))))) THEN
I was trying to compare two dates on the Hindu lunar calendar to see if one was on or before the other.
I guess I'll have to figure out a way to break it down into something with nested IF's..
Rick
IF (dwYear1 < dwYear2) OR _
(dwYear1 = dwYear2 AND _
(dwMonth1 < dwMonth2 OR _
(dwMonth1 = dwMonth2 AND _
((dwLeapMonth1 = %TRUE AND dwLeapMonth2 = %FALSE) OR _
(dwLeapMonth1 = dwLeapMonth2 AND _
(dwDay1 < dwDay2 OR _
(dwDay1 = dwDay2 AND _
(dwLeapDay1 = %FALSE OR dwLeapDay2 = %TRUE)))))))) THEN
I was trying to compare two dates on the Hindu lunar calendar to see if one was on or before the other.
I guess I'll have to figure out a way to break it down into something with nested IF's..
Rick
Comment