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

domoexpert · August 23

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

trafalger · August 23

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

ColemenWilson · August 23

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 23

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

domoexpert · August 23

What would be the syntax with datediff?

domoexpert · August 23

Since its the same date column

ColemenWilson · August 23

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 23

DATEDIFF(DATE, LAG(DATE) -1)

domoexpert · August 23

I cant use the window function with datediff

Best Answers