Help

Re: Adding a time set to a formulated date field

Solved
Jump to Solution
577 0
cancel
Showing results for 
Search instead for 
Did you mean: 
automadien
6 - Interface Innovator
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

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'
)```

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

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!