Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Creator
Creator

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
Creator
Creator
Author

thanks all! it  all worked out!