Rollup dates from formula's

Topic Labels: Formulas
1508 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I’m trying to do a “max” date rollup, where it returns the last date. This works on a regular date field. However, I only want to track this for “in progress” projects so I’m using a SWITCH formula to return the dates from records in progress. Once I try to rollup the formula field the “max” values aggregation no longer works.

Any workarounds or ideas? Thanks!

2 Replies 2
4 - Data Explorer
4 - Data Explorer

If anyone has a solution for this issue, I would greatly appreciate it.

5 - Automation Enthusiast
5 - Automation Enthusiast

Puedes utilizar la siguiente expresion DATETIME_PARSE(CONCATENATE(values))

Donde CONCATENATE te devolvera el string completo del date y con el parse lo conviertes a fecha.