Help

Using rollup to find the minimum date of a lookup field

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1520 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Automagical
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi - I’m trying to rollup a look up date field to find the earliest date but all I’m getting are values of ‘0’. Here’s how I’m set up:

Table A: Contains a list of events per location. For example, Location A on 1/1/2022, Location A on 1/2/2022, and so on where each location + event date is a unique row. I also created a formula field (Formatted Event Date) for the event date: DATETIME_FORMAT({Event Date},‘M/D/YYYY’)
Table B: Contains a list of locations and a lookup on Table A for Formatted Event Date. I tried creating a rollup on Table A for Formatted Event Date using MIN(Values) but it’s returning all ‘0’.

Is there a better way to rollup dates so that it’s formatted correctly??

1 Solution

Accepted Solutions
Elias_Gomez_Sai
13 - Mars
13 - Mars

You have to Rollup the actual dates. A formatted date becomes a string (text), so it makes no sense search the MIN() of a bunch of texts.

See Solution in Thread

1 Reply 1
Elias_Gomez_Sai
13 - Mars
13 - Mars

You have to Rollup the actual dates. A formatted date becomes a string (text), so it makes no sense search the MIN() of a bunch of texts.