date field in filter pane

[jayati_shrivast]

Hi all,

I have a date field in the format dd-mm-yyyy, hh-mm-ss AM/PM. It has values as follows-

19-10-2018 11:06:53 AM

19-10-2018 11:07:56AM

19-10-2018 11:09:58AM

20- 11-2018 12:09:59 PM and so on.......

I need to apply this field in the filter pane showing dates as 19 oct 2018, 20 oct 2018....but because of time the dates are getting repeated in filterpane like 19 oct 2018, 19 oct 2018 19 oct 2018, 20 oct 2018, 20 oct 2018 ......

how can i implement this??? pls help me out

[PradeepReddy · Accepted solution]

try like this..

Date(floor(TimestampField),'DD MMM YYYY')

[santhiqlik]

Hi,
Please try this..
Date(Date#(subfield(TimestampField,' ',1),'DD-MM-YYYY'),'DD MMM YYYY')

1. Subfield separates date from timestamp.
2. Date# interprets the date in given format.
3. Date converts to required format.

[santoshknc]

I also got similar issue, so i had resolved it using this expression added in the script

DATE(FLOOR(LEFT(Date_Field,10)), 'DD/MM/YYYY')

Thanks,

Santosh.