Help

Show Info if Timestamp is Between a Date Range

3298 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Allison_Reitz
6 - Interface Innovator
6 - Interface Innovator

Hello!
I’m a newbie to conditional formulas, and I’m looking for a way to check whether a timestamp for a record is between two different dates.

Fields: Timestamp, Amount Paid, Show/Hide Amount Formula, Totals Rollup Field (in another table)

I want the formula to check whether the Timestamp is between two dates (usually the 1st and 15th of the month). If the timestamp IS between those dates, it would show the amount paid (and if not, it wouldn’t show). I’d then like to use that data in a “Totals” Rollup Field for that date range in another Table.

12 Replies 12
Allison_Reitz
6 - Interface Innovator
6 - Interface Innovator

Yes! Exactly :slightly_smiling_face: How did you do that?

Allison_Reitz
6 - Interface Innovator
6 - Interface Innovator

Awesome! Thanks so much :slightly_smiling_face: