Discussion board where members can get started with Qlik Sense.
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!
Go to Solution.
applymap (temp, num(orderdate)) AS date
May be try this
Floor(ApplyMap('temp', orderdate)) as date.
you could use num also here
Num(ApplyMap('temp', orderdate)) as date
thanks all! it all worked out!