Timeline for Convert String to Date in Formula Field (and then get the YEAR)
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 19, 2019 at 9:37 | comment | added | Nazeer Ahamed | I get the right result when using below formula in detail page, whereas in the report on related list it shows as "#Error!" - any idea? Formula: DATEVALUE(date1__c ) - DATEVALUE(date2__c). Both fields are text data type containing datetime value. | |
| Apr 12, 2016 at 2:46 | vote | accept | hereLiesThisTroper | ||
| Apr 12, 2016 at 2:46 | comment | added | hereLiesThisTroper | Oh wow this is amazing! Your last suggestion is the thing that I've been looking for! Thank you very much! I'll also change the date format for Date_Key__c to YYYY-MM-DD just in case we need to get the DATEVALUE in the future. For now the LEFT(Date_Key__c, 4) works for us. Again thanks! | |
| Apr 11, 2016 at 17:30 | history | answered | Jenny B | CC BY-SA 3.0 |