Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Update date and time based and on another date and time but no later than 10:30PM PST

Topic Labels: Automations
Solved
Jump to Solution
1903 14
cancel
Showing results for 
Search instead for 
Did you mean: 
airballer86
7 - App Architect
7 - App Architect

Hi, I'm trying to update one date and time field {end date} based and on another date and time field {start date}. The catch is the {end date} cannot be later than 10:30PM PST (2024-09-01T10:29:59-08:00).

 

14 Replies 14

@TheTimeSavingCo I think I confused myself lol. the time in the {end date} field will be 10 hours later than the time in the {start date} field BUT cannot be later than 2230. I think that is what you're saying above. 

Hmm, does this look right? 
Screenshot 2024-09-25 at 10.24.52 PM.png

@TheTimeSavingCo column v2 does look correct. Thank you!

Great!  Sorry, I forgot to include the formula:

IF(
  OR(
    DATETIME_FORMAT(
      {Actual End in PDT},
      'HH'
    ) > 22,
    AND(
      DATETIME_FORMAT(
        {Actual End in PDT},
        'HH'
      ) = 22,
      DATETIME_FORMAT(
        {Actual End in PDT},
        'mm'
      ) > 30
    ),
    (DATETIME_FORMAT(
      {Actual End in PDT},
      'DD'
    ) + 0) - 
        (DATETIME_FORMAT(
      {Start},
      'DD'
    ) + 0) != 0
  ),
  DATEADD(
    DATETIME_PARSE(
      DATETIME_FORMAT(
        Start,
        'DD MM YYYY'
      ),
      "DD MM YYYY"
    ),
    22.5 + 7,
    'hours'
  ),
  DATEADD(Start, {Hours to add}, 'hours')
)

@TheTimeSavingCo thanks so much this worked as expected!