How do you modify date display in Current Selections Box?

[#1]

Hi there,

I'm having problems modifying my Date field in the current selections box. it's displaying the TIME as well as the DATE and i'm only interested in viewing the DATE. Below is a screen shot of what it looks like. Anybody know how to fix this? I think it's an easy fix but I can't seem to figure it out.

[lucas4bi]

Go on Document Properties and on the sheet "Number" select SaleDate and set the format DATE

[matt_crowther]

I'm assuming that it's related to how the actual field itself is formatted as I have the below basic Current Selections Box where I haven't had to do any additional formatting / tweaking to get it to where you need:

So to get to that point simply add a date(SalesDate,'dd/mm/yyyy') as SalesDate in your load script.

Hope that helps,

Matt - Visual Analytics Ltd

[#4]

Hello Mike,

You have to do this at the data level I beleive. In the Load statement where you have (YourDateField) do a Date(your fieldname), 'MM DD YYYY') as NewDate and then do a reload. This way it picks up only the mentioned dates and you can use them the way across the application. As I have read it and if you want the time in some charts for some reason then you have to do it a different way as this removes the time away for good..

ANDY

[#5]

Hi Luca. this was the quickest and easiest solution offered. It works and thanks for your help.