Formula for Date
Hi, I am trying to figure out a formula that will show 2 days after the record is created. I have a date field [Response Needed By] and I want it to automatically populate the date for 2 days af...
Forum Discussion
You can make a formula date field.
[Response Needed By] = [Date Created] + Days(2)
------------------------------
Mike Tamoush
------------------------------
[Response Needed By] = [Date Created] + Days(2)
------------------------------
Mike Tamoush
------------------------------
- I wanted to make [Response Needed By] the field with the formula. That formula is giving me an error. Should I create another field?
------------------------------
Fatima Khan
------------------------------- Sorry, I forgot Date Created is a date/time field. Try this:
ToDate([Date Created]) + Days(2)
------------------------------
Mike Tamoush
------------------------------- Thank you. I was using ToDay instead of ToDate.
------------------------------
Fatima Khan
------------------------------
- Yes, your [Response Needed By] would need to be a formula date. Can you post your code and the error message?
------------------------------
Mike Tamoush
------------------------------
