Skip to main content

Hi team!


I’ve been using this wonderful formula to set a due date for something, but the issue I have is that it defaults to 12:00AM. How would I append this formula to set it to, say, 4AM?




Thanks!

Hi automadien, you’d just need to do another DATEADD() to it, where you add 4 hours to the result. This should work for what you’re looking for:


DATEADD(

  DATEADD(

    DATEADD(

      TODAY(), 

      -1, 

      'month'

    ), 

    -(DAY(TODAY()) - 1), 

    'days'

  ),

  '4',

  'hours'

)```

Hi automadien, you’d just need to do another DATEADD() to it, where you add 4 hours to the result. This should work for what you’re looking for:


DATEADD(

  DATEADD(

    DATEADD(

      TODAY(), 

      -1, 

      'month'

    ), 

    -(DAY(TODAY()) - 1), 

    'days'

  ),

  '4',

  'hours'

)```

Spectacular. Thanks Adam, have a great day!

Reply


Terms & Conditions