Help

Re: Rollup smallest date/time past now

Solved
Jump to Solution
467 0
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.