topic Date Format different when published to server in QlikView https://community.qlik.com/t5/QlikView/Date-Format-different-when-published-to-server/m-p/73762#M774084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Date Format different when published to server https://community.qlik.com/t5/QlikView/Date-Format-different-when-published-to-server/m-p/73762#M774084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-Format-different-when-published-to-server/m-p/73762#M774084 Anonymous 2020-11-25T16:16:04Z Re: Date Format different when published to server https://community.qlik.com/t5/QlikView/Date-Format-different-when-published-to-server/m-p/73763#M774085 <HTML><HEAD></HEAD><BODY><P>Perhaps it helps if you explicitly define the date format using the Date() function: date(MyDate, <EM>'YYYY-MM-DD'</EM>). Replace YYYY-MM-DD with whatever date format you actually want to see.</P></BODY></HTML> Wed, 09 May 2018 05:39:52 GMT https://community.qlik.com/t5/QlikView/Date-Format-different-when-published-to-server/m-p/73763#M774085 Gysbert_Wassenaar 2018-05-09T05:39:52Z