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

domoexpert · 2023-08-23T18:49:33+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Beast Mode

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

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

Field*1

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

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

What would be the syntax with datediff?

Since its the same date column

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

Field*1

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

DATEDIFF(DATE, LAG(DATE) -1)

I cant use the window function with datediff