Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago
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 Date].[Day],MINUTE).  The Time to Access Column is formatted at a whole number data type and returns values like -64561883 for a time date that is 19 minutes apart.
 
Any thoughts on what I am doing wrong?
Need Help
  • grandtotal's avatar
    grandtotal
    3 years ago

    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)

     

2 Replies

  • grandtotal's avatar
    grandtotal
    Icon for Resolver III rankResolver III
    3 years ago

    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)

     

    • PowerBINoob24's avatar
      PowerBINoob24
      Icon for Resolver I rankResolver I
      3 years ago

      That was it....just ahd to remove the .DAY  Thanks!  It's the little things.....