884
Hi guys,
I am Looking for a dynamic filter that takes today's datetime and gives me all the entry's in current year,previous Year,current year quarter 1,current year quarter 2 ,current year quarter 3,current year quarter 4
Show something like this image.(date-time filed to get record)
Thanks for all the help - i really appreciate it!
*This post is locked for comments
You can pass your date field as parameter, and use a SQL Statement to generate the list of values, based on that parameter...
Something like:
SELECT year(@MyDate) As [CurrentYear], year(@MyDate) - 1 As [PastYear]...
Hope this helps, or clarify a little further if this is not what you need.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (