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.
Thanks a lot. Yes i used the same formula only and tried in alteryx.
I'm comparing a constant date 04/30/2019 with different dates like 05/15/2019, 06/01/2019 i should get a result of 1 , 2 respectively. But when use the formula DateTimeDiff([DateEND],[DateSTART],"months") all I'm getting in one month lag.
i have attached the excel out of the formula used which does not gives the proper result with that of expected result.