I m using two datetime values to calulate the difference between them.
update_date - prev_update_date
the data type is datetime.
Let me know if it yeilds the correct results. Does it calculate the difference correctly if i use the minus operator directly on these two dates?
You can subtract dates like that, Tableau calculates the days between. If you want to do calculate the difference in hours, etc., use the DATEDIFF command. Here's a link to the help on DATEDIFF: