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 dates from formula's

Topic Labels: Formulas
1972 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner_Marketi
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
Michael_McElduf
4 - Data Explorer
4 - Data Explorer

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

Oscar_Diaz
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.