+ Start a Discussion
David LanganDavid Langan 

referencing "Start Date" and "End Date" in the reports tab

I want to modify this formula to stop referencing today's date and instead reference the "Start Date" and "End Date" fields in the reports tab.
 
IF(
AND(
Sales_Period_Ending__c <= TODAY(),
Sales_Period_Ending__c >= DATE(YEAR(TODAY()), 1, 1)
),
Premium_Sold__c ,
0
)
 
What can I do?
 
 
Thanks,
 
 
Marc PannenbergMarc Pannenberg
Hi David,

are you talking about the time Start Date and End Date in the Time Frame section of the report result page? If so, then what you are trying to do is not possible. You can only reference other fields or formulas (either on the same record or on a related parent record) functions (such as TODAY())or static values.

Marc
David LanganDavid Langan
That's what I thought..
 
I've worked around it by creating calculated fields in the sales object for each quarter by entering the criteria that defines that quarter as the formula.
 
I'm planning on creating calculated fields for defined months too (the management team likes that level of detail).