Jump to content

Expression to find the closest date in a [timestamp] column with date that is less than the date in present row

Arpan Tyagi

Recommended Posts

I have a user column and a timestamp column, I am looking for the previous nearest timestamp of the same user, I have been banging my head over it for the last few hours but cant come up with an expression, can anybody help me


UserTimestamp Required Column

A 7/29/2021 3:55:06 AM 7/22/2021 3:55:06 AM

A 7/21/2021 3:55:06 AM None

A 7/22/2021 3:55:06 AM 7/21/2021 3:55:06 AM

B 7/26/2021 3:55:06 AM None

B 7/28/2021 3:55:06 AM 7/26/2021 3:55:06 AM

C 7/21/2021 3:55:06 AM None

B 7/29/2021 3:55:06 AM 7/28/2021 3:55:06 AM

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...