Hello,
Has anyone updated the date formats for the Date Output Set elements? We are wanting to drop the time and change the format to dd/mm/yyyy for the membership Expire Date in particular. Not sure if the best place to do this is in the view or in TR_QUERY_ELEMENT.
Thanks in advance,
Kelly
Hi Kelly,
We have a TASK ticket on that and the last word we have is you will need to create custom views to reference short dates. These will come in as a string I believe. Maybe they will provide and output datamask in the future.
Thanks Troy. Not really what I wanted to hear. I thought the idea of these new views was we wouldn't all need to create Custom Views just to change the date format!
Kelly are you talking about the way datetime values are shown in the results tab in the new List Manager? Or the way that datetime values get exported from there? We do have plans to present them on the results tab in a local format rather than in the yyyy-mm-dd hh:mm:ss that you see now, but it was something that didn't make it into the current release. But to the system they are datetime values and if you want them as date strings, then you will have to reformat them. The new views are much more about consistency of data for reporting and not really for presentation, as formatting is usually handled by a report or reformating a cell after data is exported.
Hope that helps. Thanks!
Hi Chuck.
Both.
For the exporting an example would be: we use the Expire Date for memberships to print on Member cards and when the users export this they have to reformat them, we run this quite frequently so it becomes a bit of an annoying step.
Hmm, I guess I don't really want to create a custom view to only format a few date output elements.
Thank you for responding.