Creating Formula To Report

Question

Hello,
I am wanting to add a Report with a formula for this.
It takes Todays Date, adds 2 days and gives a report that has "Return Date" that matches the date from 2 days from today.
Example:
(08/22/2023, 2)&nbsp; = 08/24/2023
Report will give any "Return Date" that has the date 08/24/2023.

I am having a hard time doing this and probably over thinking.
Thank you!------------------------------Eric Arellano------------------------------

markshnier__you · Answer

If you just want to do a filter on a report, you can set the filter where [Return Date] is 2 days "in the future".&nbsp;

If you want to make a new field to calculate if today is 2 days before the return date,&nbsp; then it would be a formula checkbox ox field type
[Return Date] - Days(2) = Today()

&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Creating Formula To Report