I want to get date difference between lagging date values. How to do this?

Q&A
, ,
1

image

I want to get date difference between lagging date values. How to do this?

2

Thanks for your question @Namrata.

@DylanM and @duncan could you look at this Monday morning?

3

Hi @Namrata

you need to calculate the previous date first

lag
(
     date_of_purchase
     ,[date_of_purchase DESC]  
     ,1
)

Then you can calculate the difference

dateDiff(max(date_of_purchase),previous_date,"DD")

BR

1 Like
4

Hello @Namrata !

@ErikG 's suggestion should work for this!

5

Thanks @Kristin, @ErikG and @duncan. This helps!

2 Likes