When a user filters a Date Column in the Data Grid, does anyone know how they can filter by a rolling date (ex: "today") where "today" changes every day or if they search a range of dates (ex: "today" - 10 days)?
can you please share some sample (ui or more detail) to understand the requirement better.
for filtering date there is discussion you can check that
https://www.outsystems.com/forums/discussion/93861/outsystems-data-grid-filter-a-datetime-column-with-date-filter/
if you are looking to convert date to human readable format than you can use
https://www.outsystems.com/forge/component-overview/21024/humanizerdemo-o11
https://www.outsystems.com/forge/component-overview/4314/humanizer-o11
More specifically, when I filter a Date column by a condition:say, between Feb 24th (4 days ago) and (today) Feb 28th)
And then I save that filter; I want the filter to automatically update based on when "today" is: So if Today is March 7th, the filter will automatically be updated to between March 3rth and March 7th.So, in the greater-than field, I would put "4 days ago," and in the less-than field, i would put "Today" Allowing the dates on the filter to be dynamic based on when the user is accessing the page.
Hi @Steven Stein
Can you try this approach: