Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Contributor III
Contributor III

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!

1 Solution

Accepted Solutions
giovanneb
Creator II
Creator II

applymap (temp, num(orderdate)) AS date

View solution in original post

4 Replies
giovanneb
Creator II
Creator II

applymap (temp, num(orderdate)) AS date

sunny_talwar

May be try this

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

avinashelite

you could use num also here

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

thewillemzelluf
Contributor III
Contributor III
Author

thanks all! it  all worked out!