I am storing date data in an MDA table in MM/DD/YYYY format, but when I use that field as a token in a CTA, it’s displaying as YYYY/MM/DD. It should display the way it is stored in the system.

How it is captured in the system

I am storing date data in an MDA table in MM/DD/YYYY format, but when I use that field as a token in a CTA, it’s displaying as YYYY/MM/DD. It should display the way it is stored in the system.
I am storing date data in an MDA table in MM/DD/YYYY format, but when I use that field as a token in a CTA, it’s displaying as YYYY/MM/DD. It should display the way it is stored in the system.
+1.
And not only that format change.
Found the differences between showing the date in Rule preview mode vs Report.
The data stored in MM/DD/YYYY format but when we preview the data in Rule Fetch it is displayed as MM-DD-YYYY.
Screenshot from Report Builder
Screenshot from Rule Preview:
Thanks.
cc:
That should have nothing to do with the user locale. The Tokenization process should respect the value and format of the source field.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.