Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thewillemzelluf
New Contributor II

date format

Hello everyone,

I have a problem with dates. I use an applymap to get the correct date in a table.

applymap (temp, orderdate) AS date.

However, the date will be shown as follows: 19-20-2017 00:03:04. Now I want something like 43123 or 43124. Any idea how I can convert this with an applymap?

Thanks in advance!

Tags (1)
1 Solution

Accepted Solutions
giovanneb
Contributor II

Re: date format

applymap (temp, num(orderdate)) AS date

4 Replies
giovanneb
Contributor II

Re: date format

applymap (temp, num(orderdate)) AS date

MVP
MVP

Re: date format

May be try this

Floor(ApplyMap('temp', orderdate)) as date.

Re: date format

you could use num also here

Num(ApplyMap('temp', orderdate)) as date

thewillemzelluf
New Contributor II

Re: date format

thanks all! it  all worked out!