You need to sign in to do that
Don't have an account?
Anne Larsen 2
The following formula field shows Error#! in my report when the Order Date is 2/29/2016 (leap year). Anyone know how to fix?
IF( AND( YEAR(TODAY())-1 = YEAR(OrderDate__c), TODAY()-1 >= Date(year(Today()), month(OrderDate__c), day(OrderDate__c))), OrderAmount__c, 0)
Thanks! Anne
Thanks! Anne
One way is to set ignore leap year dates...
Hope this can help somehow
All Answers
One way is to set ignore leap year dates...
Hope this can help somehow
but if you prefer the condition to be precise, let's add some leap-year computation...
(there might be some syntax error on this)