Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Adding a time set to a formulated date field

Solved
Jump to Solution
169 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!