Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simotrab
Creator III
Creator III

Choose last but one date

Hi community,

short question about dates: how could I choose the last but one date from a group of date?

The formula I need is something like

today()-LastButOneDate()

Thanks in advance!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Perhaps like this: Today() - Max(YourDateFieldHere, 2)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Perhaps like this: Today() - Max(YourDateFieldHere, 2)


talk is cheap, supply exceeds demand
simotrab
Creator III
Creator III
Author

Thanks a lot!