Forum Discussion
Date range filter based on dates between two date fields
Hi,
I have solved a similar question in the attached file.
Hope this helps.
I've applied everything to my file, but when adding the Calendar formula to my date table, it returns the error: 'A table of multiple values was supplied where a single value was expected.' My Date table is related to my data table, while yours is not. Should I create a separate Calendar table for this purpose, or is that not considered best practice? or is the error related to something else?
Also, your file is exactly how I want mine to function—thank you so much for providing it!
You are welcome. Please follow exactly what i have done. If there is no relationship in my file, then do not create it on yours.
I applied exactly what you have done and this works perfectly. Thank you so much!
You are welcome.