Formula for Date

Question

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 after the record was created.Thank you------------------------------Fatima Khan------------------------------

miketamoush · Answer

Sorry, I forgot Date Created is a date/time field. Try this:ToDate([Date Created]) + Days(2)------------------------------Mike Tamoush------------------------------

miketamoush · Answer

You can make a formula date field.[Response Needed By] = [Date Created] + Days(2)------------------------------Mike Tamoush------------------------------

fatimakhan · Answer

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
------------------------------

miketamoush · Answer

Yes, your [Response Needed By] would need to be a formula date. Can you post your code and the error message?------------------------------Mike Tamoush------------------------------

fatimakhan · Answer

Thank you. I was using ToDay instead of ToDate.------------------------------Fatima Khan------------------------------

Forum Discussion

Formula for Date