How to change a date time field to just display the date

[#1]

I'm newbie with Qlikview and I have a chart that has a datetime field MM/DD/YYYY HH:MM:SS and I want to change it so that the time isn't displayed.

In the picture below, i just want to eliminate the time after the date.

[disqr_rm]

If you just want to change on one chart, just go to "Number" tab, click on the field you want to change and chose Date radio button.

If you want to change everywhere, then best would be to load it as date only. For that you can use date() function, like LOAD date(DateTime) as Date.

Hope this helps.

[#3]

Hey Rakesh,

The Date field is not available in the NUMBER table for modification. See picture below

[#4]

Hi Change the script to read

Load

Date(floor(Date), 'DD/MM/YYYY') as Date

The Date in the floor (Date) brackets is the name of your column, the first date is the Date finction.

The floor function takes it to the start of the day

Hope this is of help,

Regards,

Neil

[#5]

You can also go to Document Properties -> Numbers. Then pick the date field and set the format from there.

[#6]

use date() function in your script, just like rakesh said.

date(DATEFIELD) as DATENAME, use DATENAME field in your chart.

[disqr_rm · Accepted solution]

I think you got many answeres for this, but another one wouldn't hurt. 🙂

Instead of putting Date field in the dimension, put date(Date).

But I am sure you have it working by now.