Skip to main content
Topics#Data ManagementRenata Mattson-Drozdowski's Question
Renata Mattson-Drozdowski (Vitalyst) asked in #Data Management
Jun 6, 2018, 6:48 PM

Datevalue formula returning #Error! even though syntax is good.

Trying to convert text data from external data source into a date format using the datevalue formula in a new field.  
2 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Jun 6, 2018, 8:46 PM
    If you're getting a Bad Result instead of a Syntax Error, can you create a Report or a List View that displays all of the Fields in your Formula and the Formula results side-by-side and post a screenshot?  It's gonna make troubleshooting the Formula a LOT easier if we can see the Input and the Output side-by-side.  

     

    Tips & Tricks: Measure twice and cut once with Formula QC List Views and Reports

     

    https://success.salesforce.com/answers?id=9063000000046BfAAI
Write an answer...
0/9000