date format

[thewillemzelluf]

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!

[giovanneb · Accepted solution]

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]

thanks all! it  all worked out!