Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I used Date(Floor(created_tm), 'M/D/YYYY') as [created_tm] in my load script and it seems to be working fine now.
I used Date(Floor(created_tm), 'M/D/YYYY') as [created_tm] in my load script and it seems to be working fine now.