This is coming out to be a date format beast mode. How can i change this to integer?

domoexpert · August 2023

(((DATE - Lag(DATE,1) over (partition by ID,FAMILY order by INVOICE))))

trafalger · August 2023

use a DateDIFF to calculate the number of days between the dates!

ColemenWilson · August 2023

Agreed on DATEDIFF(). Also, adding a *1 to a field will force it to a number:

Field*1

or

(CASE WHEN Field = 'Cat' THEN ID END)*1

trafalger · August 2023

use a DateDIFF to calculate the number of days between the dates!

domoexpert · August 2023

What would be the syntax with datediff?

domoexpert · August 2023

Since its the same date column

ColemenWilson · August 2023

Agreed on DATEDIFF(). Also, adding a *1 to a field will force it to a number:

Field*1

or

(CASE WHEN Field = 'Cat' THEN ID END)*1

trafalger · August 2023

DATEDIFF(DATE, LAG(DATE) -1)

domoexpert · August 2023

I cant use the window function with datediff

Beast Mode