Filter in straight table for dimension column

[kurakuaa]

Hi All,

Below is the date column displaying data in straight table as a dimension.

Date 

11-12-2019 00:30:00

11-12-2019 01:30:00

11-12-2019 02:30:00

12-12-2019 00:30:00

12-12-2019 01:30:00

So now in chart grid it should show for date column with date timestamp, but in drop down for same date column it should without timestamp and only date should be shown.  I need below result in drop down. 

11-12-2019

12-12-2019

Only these dates should be shown. 

Please can anyone help me on this.

Thanks in advance.

Thanks, 

Avinash 

[Arthur_Fong · Accepted solution]

Try this:

In Date ListBox Properties > General > Field > Dropdown select <Expression> :

=Date#(SubField(Date,' ',1),'DD-MM-YYYY')

Thanks and regards,

Arthur Fong

[ramasaisaksoft]

Just try to use

Date(Date Filed/your Dimension Name) as New field Name.it will gives the date of that field

[kurakuaa]

Thank you it is working.

Thanks,

Avinash