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.

Rollup smallest date/time past now

Topic Labels: Formulas
Solved
Jump to Solution
1500 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dev_Ops
5 - Automation Enthusiast
5 - Automation Enthusiast

This might be simple, but I fail to get my head around it. Help, please.

We have 2 tables;

  • Profile - name, image, etc
  • Availability - date/time, profile linked record
    13/2/2022 4:57pm
    20/2/2022 4:57pm
    23/2/2022 4:57pm
    11/2/2022 4:58pm

On Profile table, we need to roll up the Min(values), but only display date/time past NOW.
If now date/time is 19/2/2022 4:45om the correct answer needs to be: 20/2/2022 4:57pm

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

In your Availability table, have a formula field that calculates if the date/time is after NOW.

IS_AFTER( {date/time field}, NOW() )

Then in the Profile table have rollup that uses MIN(values) with a condition based on the formula field.

Note that NOW only updates every 5 minutes to two+ hours. So it is almost always behind. If you date/times are always on different days, this probably won’t be a problem.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

In your Availability table, have a formula field that calculates if the date/time is after NOW.

IS_AFTER( {date/time field}, NOW() )

Then in the Profile table have rollup that uses MIN(values) with a condition based on the formula field.

Note that NOW only updates every 5 minutes to two+ hours. So it is almost always behind. If you date/times are always on different days, this probably won’t be a problem.

Dev_Ops
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you both. It’s solved.