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

domoexpert

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

trafalger

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

ColemenWilson

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

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

domoexpert

What would be the syntax with datediff?

domoexpert

Since its the same date column

ColemenWilson

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

https://community-forums.domo.com/main/discussion/comment/74803#Comment_74803

DATEDIFF(DATE, LAG(DATE) -1)

domoexpert

I cant use the window function with datediff