This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using below logic to get the desired result(data for 2016 and 2017 only) , but alteryx includes Nov-2015 and Dec-2015 records as well . I am not sure why it includes this . does alteryx convert first in months then convert it into years .Can anyone help me out on this ?
iif(DateTimeDiff(DateTimeNow(),[PO_CREATION_TIME], "years")<=1 AND [PO_CREATION_TIME] <=DateTimeNow(),1,0)