Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with multiple date fields
DateA, DateB, DateC, DateD, DateE, DateF
I need to create a filter - a Text box maybe with
Filter - 'Today', 'Yesterday', 'This Week', 'Last Week', 'Last Two Weeks', 'This Month', 'Last Month', 'Last Two Months', 'This Year', 'Last Year',
When I select any value, that should apply on all date fields.
Check out the Canonical Date . If you don't use the [date type] in your calculation, I think you will reference all dates on the record.