How do I use "TODAY" in the criteria of a roll-up field without errors?

I have a roll-up field in accounts that looks at opportunities. I want to get a value for all records with a certain status (which is easy), have an effective date less than today and an expiration date greater than today.

I've tried "today" and "today()" but it get errors saying it wants data in the format 3/6/2012.

I also tried date(year(today()),month(today()),day(today())), but got the same error.

How do I get around errors of using the date words in such criteria?

4 respuestas

Matthew Lamb (10K Advisors)
7 mar 2012, 17:40
You unfortunately can't. Roll-up Summary fields don't support relative / dynamic date functions like TODAY().

Check this idea, it's got a statement from someone on the PM team @ Salesforce:

https://sites.secure.force.com/success/ideaView?id=08730000000BrUAAA0

And also vote for this idea:

https://sites.secure.force.com/success/ideaView?id=08730000000BqCGAA0

Agregar un comentario

Escribir una respuesta...

0/9000

How do I use "TODAY" in the criteria of a roll-up field without errors?

Data Management

Aprendizaje relacionado

Más ayuda