Adding a time set to a formulated date field

[automadien]

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?

Using a formula to return the date of 1st day of last month Formulas

Hi all, New to Airtable and by no means a whizz when it comes to formulas. In short, I need to create a formula that will return a date of the 1st day of last month. In other words, today (May 21st), the field should show a date of April 1st 2020. As soon as we hit June, that date should change to May 1st 2020. Any idea how I could do this? Thanks all…

Thanks!

[TheTimeSavingCo · Accepted solution]

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

[automadien]

Spectacular. Thanks Adam, have a great day!