Hi All,
I'm trying to make a rich text field that helps the user remember which dates to enter data for in the subsequent field. We have a field for two weeks prior, and one week prior. So, if the user is entering data today, 8/17/21, then the two week prior formula field should display 08/01/21-08/07/21, and the one week prior formula field should display 08/08/21-08/14/21.
So far I've only been able to get the start of this week with ToText(FirstDayOfWeek(Today())). It won't let me subtract 14 from Today().
Thoughts?
------------------------------
Daniel Johnson
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.