I have a database of research findings, and I’ve been asked to prepare a report that lists the most recent findings so I’ve been trying to construct a table view that only shows records that have been modified in the past week or so; however, I’m not sure what’s the best way to do this.
TONOW(LAST_MODIFIED_TIME()) gives me a column with the elapsed time since the last modification, but when I try to wrap it in a conditional which I can then filter by…
IF(TONOW(LAST_MODIFIED_TIME()) <= 14, “Recent”, “Previous”)
…I just get a column full of “Previous” even when it’s clearly wrong.
I imagine it’s because the two sides of the conditional are different data types (7 days vs 14) and so the boolean is failing to work as intended, but I can’t figure out how to cast the first side as an integer and changing “14” to “14 days” makes the formula invalid.
Would love some help or advice on a better direction as I feel like I’m missing something obvious! Thanks in advance!