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.