Mark "Period" based on Date

Question

I have two dated in my data.

Lets say,

30/09/2023 and 30/11/2023

I want to add a column for Period and mark the most recent one as "Current and the older one as "Previous".

Dates will keep changing and the difference in months or years may vary too so I can not use the if formula.

IS there any way i can do this?

CoG · Answer

Here is one way that I believe will do what you need:

Sample Workflow.yxmd

StutiG612 · Answer

I will only have two dates in this column. So i just need to have the latest one as current and other one as previous. i can not really mention via record id here as the data is very comprehensive. It has multiple lines of current and previous date.

StutiG612 · Answer

Both my dates are in the same column. Any alternative for that?