We have inserted a custom date field into an email that fires in a workflow rule. When the date field displays in the email, the value is returned in this format: YYYY-MM-DD hh:mm:ss. What function can I use in the email that will return only the date in a MM-DD-YYYY format?
I’ve tried ToDate({$FieldName}) but that returns the actual text “To Date(YYYY-MM-DD hh:mm:ss)” in the email.
Hi
You can format the data field using the ToString function: ToString($DateField, “MM-dd-yyyy”).
Try that out and let us know how you get on!
Pete
I have formatted this in a workflow and had success
{DateValue($DateField,'MM/dd/yy')}
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
