Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Contributor II

Date Format different when published to server


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.

1 Reply
MVP & Luminary
MVP & Luminary

Re: Date Format different when published to server

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.

talk is cheap, supply exceeds demand