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!

Terms & ConditionsAccessibility statement