I created a survery requesting users to enter a test date. Based on user responses, is there a way to filter my report to only show records where dates are within 14 days from today?
I tried exploring different kind of filters but nothing seems to be able to calculate based on dates. Any recommendations?
Solved
How do i filter report data based on 2 weeks from entered date?
Best answer by mingchiat
Hi MSobotta,
Yeah, seems like that is one option. In the end, I opt to filter my report to only export data captured today or yesterday. There may be some overlap but for the time being it works for my solution. Thank you for your suggestion. 😀
+25Best I could think of in the app would be to sort on date otherwise exporting to excel and having a macro built would be your quickest option.
Hi MSobotta,
Yeah, seems like that is one option. In the end, I opt to filter my report to only export data captured today or yesterday. There may be some overlap but for the time being it works for my solution. Thank you for your suggestion. 😀
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.