You need to sign in to do that
Don't have an account?
David 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
)
AND(
Sales_Period_Ending__c <= TODAY(),
Sales_Period_Ending__c >= DATE(YEAR(TODAY()), 1, 1)
),
Premium_Sold__c ,
0
)
What can I do?
Thanks,
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