Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
avner_raz
New Contributor III

Date Format

Hi All,

The date field in my model starts well on the Raw-data section (01/09/2013 14:10:00), but in the Dw it goes out of format and looks like that:41518.590277778.

is there a magic spell to keep it in date format?

thanks

avner

1 Solution

Accepted Solutions
Partner
Partner

Re: Date Format

Try:  timestamp(yourfield, 'MM/DD/YYYY hh:mm:ss')

2 Replies
Partner
Partner

Re: Date Format

Try:  timestamp(yourfield, 'MM/DD/YYYY hh:mm:ss')

avner_raz
New Contributor III

Re: Date Format

works perfect,

thanks