This content has been marked as final. Show 4 replies
What system are you reporting against? If the underlying column is a datetime type, then Xtraction will display the long format complete with time. If you want this to contain a date only you will need to convert that in the data model field.
ie: SQL Server
cast(mydatetimecolumn as date)
Actually, I don't think that will work. I've attempted to do this with customers and it didn't work. A code change would be required for this.
If the field in the data model is indicated as a date field, then Xtraction will always show it as date/time. A date-only field will show as midnight for the time portion. You would have to add a cast as varchar and set it to be a string instead of a date to get it the way you want for display in record lists.