Discussions

 View Only
  • 1.  Formula for Date

    Posted 01-18-2023 15:20
    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
    ------------------------------


  • 2.  RE: Formula for Date

    Posted 01-18-2023 15:24
    You can make a formula date field.

    [Response Needed By] = [Date Created] + Days(2)

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 3.  RE: Formula for Date

    Posted 01-18-2023 16:33
    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
    ------------------------------



  • 4.  RE: Formula for Date

    Posted 01-18-2023 20:54
    Yes, your [Response Needed By] would need to be a formula date. Can you post your code and the error message?

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 5.  RE: Formula for Date

    Posted 01-18-2023 20:56
    Sorry, I forgot Date Created is a date/time field. Try this:

    ToDate([Date Created]) + Days(2)

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 6.  RE: Formula for Date

    Posted 01-19-2023 06:28
    Thank you. I was using ToDay instead of ToDate.

    ------------------------------
    Fatima Khan
    ------------------------------