I am trying to use a lead token to populate dates into an email. I created the new token based on the data I want reflected from the excel sheet, however when I preview the Email Send via person view, the data does not populate. Other tokens are working just fine in the same email - it's only the one with dates that won't work. I tried changing the 'type' multiple times from date to text to integer - none have worked. I'm wondering if this is an issue with the way I built the token, or if it's an Excel import issue.
Example:
Data in Excel Column I want populated (yyyy): Token I created: {{lead.Flex Field-STM Since Date:default=edit me}}
Flex Field-STM Since Date
2018
2017
2018
1985
2013
Solved! Go to Solution.
Just a 4-character year isn't a Date. It's an alphanumeric String (don't be tempted to make it an Integer). So try the import again with the datatype as String.