Is it possible to create a calculated field that is only filled every 3 months?
I have a date field autocalculated when a new record is registered. I need to create a date calculated field that refers to this initial field. This field should only show the date every 3 months.
Thanks in advance
- calculated field
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
You can also accomplish this with a calculated field. See below for a sample calculation that would display the First Published date in another field every 3 months, for the entire month. If you only need it there on a specific date, you would have to modify the formula to add a check on the DAY() as well.
MONTH([First Published]) = MONTH(TODAY()),
MONTH([First Published]) = MONTH(TODAY()) + 3,
MONTH([First Published]) = MONTH(TODAY()) + 6,
MONTH([First Published]) = MONTH(TODAY()) + 9
Thanks, I did not think about the possibility of datafeed.
Would the idea be to run a datafeed quarterly and fill in the field with the date of the day?