I have a text field using the format YYYY-MM-DD
I need a formula field to change it to a useable Date field.
The simple: DATEVALUE(TextFieldDate__c)
errors out. I found the following help page from the community here: Formula to convert text into a Date
But it has a syntax error on "extra null" that I can't seem to get rid of. So, I don't even know if it'd work if I got rid of the syntax error.
Any nudge in the right direction would be greatly appreciated.
2 answers
Hi David ,
Try this
IF ( NOT(ISBLANK(TextFieldDate__c) ),DATEVALUE(TextFieldDate__c),NULL)
