Date functions

[krishnacbe]

Hi

I have a date field in a list box. I have to display only the date part. Using format date I have displayed date alone. But duplicate values are available in the list box, as same date but different time are available. Please let me know how to remove the duplicate values.

Thanks in Advance.

[Anonymous · Accepted solution]

Hi, wrap your timestamp with Floor() to remove the decimal (i.e. time) part.

[krishnacbe]

Hi

Thanks for your quick response.