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.
The datetimediff gives you only an integer response, so if you want to have your result in decimals, I suggest you to calculate the difference in minutes and then divide it per 60*24 (minutes*hours) to give you the same answer but with decimals.
Your another issue is related to the "Sem data" possibility transforming your field in a string column.
I think the issue is that the DateTimeDiff function only returns results in whole numbers, so it will return 1 or 2 or 3 days, but not 1.5 days. If you need greater granularity, you'll have to select the unit as 'hours' and convert it to days yourself.
@fmvizcaino@DavidP thank you so much for your help. I resolved it by using hours in DatetimeDiff then dividing this by 24 and using 'round' formula to round the number. At the end I got what I need (44.49 and below is out of my analysis and the rest is in).