Is there a way to see exactly how the values would look like once it is published in the server? I have a date field that looks okay in desktop and in web view but when published in the server it is showing the number format. Wondering if there is a way from desktop to detect or see this so that I can properly modify it before it gets published in the server. It is a different person publishing and managing the server. Hence I'd like to resolve date format issues before I pass it on if I am able to see how the data would look on the server using my desktop.
Perhaps it helps if you explicitly define the date format using the Date() function: date(MyDate, 'YYYY-MM-DD'). Replace YYYY-MM-DD with whatever date format you actually want to see.
