Date Field Filter

[techvarun]

I have a date field with timestamp in it. so in list box am getting N number of entries i need to show only one entry for the day

Regards & Thanks in advance

[alexandros17]

IN the listbox use the expression (at the bottom of fields list) and set date(myfield), in this way the list box shows unique values for dates

[techvarun]

Sorry dude still it is showing all the values

[alexandros17]

try date(myDate,'dd/MM/yyyy')

[tresesco]

I would suggest to use MakeDate() function. Date() function formats the value while the underlaying numric value remains same.

[techvarun]

Still its showing the same

is there any way to fetch unique date values from qvd itself?

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

     Date(Floor(Date)) as Date

     You are seeing this because you have timestamp also in the date, so you need to remove the timestamp and thus the floor function is needed as shown in above example.

Regards,

Kaushik Solanki

[#8]

I would advise you do make a new field in the back end Date(Floor(DateTimeField),'DD/MM/YYYY') AS DateField

[techvarun]

"Floor(Date) as Date" Used this in Load level and resolved the problem

Many Thanks