Dates are disabled in Date range picker

[Pragyan]

Hi,

I have a date field [created_tm] with timestamp as below:

So I have multiple values with same date in 5 min interval. 

Now i want to use date picker to choose a specific date and based on that there is another field with some values and I have to get the peak from the values for the date.

For the same I tried below while loading the date:

Date([created_tm],'M/D/YYYY') AS [created_tm],

But in my date picker dates are disabled 

Please help me getting the dates properly in the date picker.

Thanks in advance

[Pragyan · Accepted solution]

I used Date(Floor(created_tm), 'M/D/YYYY') as [created_tm] in my load script and it seems to be working fine now.