Forum Discussion
Solved
Finding difference in minutes between two date/time fields
If got a column that I'm trying to calculate the number of minutes between to date/time fields. I've currently got Time To Access = DATEDIFF('UniqueUsers'[First Access Time],'UniqueUsers'[Send Dat...
Make sure that both input columns are in datatime format.
Then try to remove the .[Day] part:Time To Access = DATEDIFF('UniqueUsers'[First Access Time],'UniqueUsers'[Send Date],MINUTE)
Make sure that both input columns are in datatime format.
Then try to remove the .[Day] part:
Time To Access = DATEDIFF('UniqueUsers'[First Access Time],'UniqueUsers'[Send Date],MINUTE)
That was it....just ahd to remove the .DAY Thanks! It's the little things.....