Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to do a sum of a $$ field where the created date is three weeks (21 days) old
=(sum({<CreatedDate={">=Date(Today()-21)"}>}Upsell_ARR__c)) is not working
But when I hard code the date it works
=(sum({<CreatedDate={">=2/21/2018"}>}Upsell_ARR__c))
When I just do the set analysis Date(Today()-21) in a text box I get 2/21/2018, which is correct
What am I missing?
Try this
Sum({<CreatedDate={"$(='>=' & Date(Today()-21, 'M/D/YYYY'))"}>}Upsell_ARR__c)
Hi,
sum({<CreatedDate={'>$(=Date(Today()-21))'}>}Upsell_ARR__c)
Try this
Sum({<CreatedDate={"$(='>=' & Date(Today()-21, 'M/D/YYYY'))"}>}Upsell_ARR__c)