Forum Academy Marketplace Showcase Pricing Features

Penultimate date

How do we do “last item -1” (Last item minus 1) on a date field?

1 Like

I had to look that word up:

pe·nul·ti·mate
pəˈnəltəmət/
adjective
last but one in a series of things; second to the last.

1 Like

old topic, but i had a similar problem. This is my solution:

In a RG I have Previous action date (text), and Next action date (input). I want to move the current action date to show up under Previous action date when I create a new Next action date.

I created a third field in the RG that searches for ‘all actions:count-1’

The previous action has :item# and takes the value from the third field that counts the total number of actions minus one.