Announcements
Hello, I have a gallery with data (data type datetime). I have to sort the data in such a way that data at the top is descending with today + 42 days. Today is between the dates in the future and the older dates.
The problem is that I have data of the type: 30.12.2250 00:00:00 (which is simply permanent / infinite). I want to filter this data out.
Can you please help me.
regards
@Alice87
I don’t understand your comments about 30.12.2250 00:00:00.
What date does this translate to? December, 30 2250?
What data source are you using: SharePoint, Excel, SQL or CDS? What column type is the data?
Please answer these questions.
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @mdevaney
it's like membership. The exit column (datatype-datetime) shows, for example, how long you have been a member. If the date is 12/31/2250, it means that the person has a permanent membership.
datasource-sql server
I want to have people at the top of my gallery whose membership is about to expire. And filter out those that are unlimited.
thank you
hi @Alice87
If( DateValue( Substitute( Left( "30.12.2250 00:00:00", 10 ), ".", "/" ) ) < Today() + 40, DateValue( Substitute( Left( "30.12.2250 00:00:00", 10 ), ".", "/" ) ) )
Will filter out dates > 40 days from today. You can then sort the results descending. Just replace "30.12.2250 00:00:00" in the formula with the date column in your data
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
